Create/Edit Success Code Set -- Fields and controls

Use the Create/Edit Success Code Set window to work with the success code sets that indicate whether a script executes successfully.

Success codes set name

Description

Specify codes

Add

Change

Remove

Remove all

OK

Apply (create mode only)

Reset (create mode only)

Cancel

Success codes set name

Use this field to specify a name for the set of success codes.

Note:

This field is read only in edit mode.

Description

Use this field to specify a description for the named set of success codes. The description can be a maximum of 128 characters.

Note:

In edit mode, this field is prefilled with the description associated with the selected success code set.

Specify codes

Use these fields to specify the success codes for the script. Use the Code field to specify the success code. Use the Condition field to specify the relation.

The following rules apply:

• The set can only have one greater than (>) condition, where the associated code must be greater than or equal to (>=) any less than (<) condition that is specified.

  For example, if you specify (>, 5) and (<, 0), the error codes are 0, 1, 2, 3, 4, 5. You cannot specify (>, 5) and (<, 6), as this will provide all numbers.

• The set can only have one less than (<) condition, where the associated code must be less than or equal to (<=) any greater than (>) condition that is specified.

  For example, if you specify (<, 0) and (>, 5), the error codes are 0, 1, 2, 3, 4, 5. You cannot specify (<, 5) and (4, >), as this will provide all numbers.

• There can be zero or more unique equals (=) conditions.

The following example shows how to set a success code set. Assume that you want to run an SQL script as a batch step. Also assume that this SQL script consists of more than one SQL statement (that is, the script contains multiple lines), and you know that each SQL statement in the script returns an SQLCODE. Because some SQL statements can return non-zero SQLCODES that do not represent error states, you must determine the set of non-error SQLCODES that any of the SQL statements in the script can return. For example, assume that the following return codes all indicate successful execution of the SQL statements in the script (that is, if any of the following conditions are met, execution of the script continues):

   RC > -1000 OR RC = -1230 OR RC = -2000

You would define the success code set as follows:

ID	RELATION	CODE
SQLSCRIPT	>	0
SQLSCRIPT	=	0
SQLSCRIPT	=	-1230
SQLSCRIPT	=	-2000

Add

Use this push button to add the values in Specify codes to the set of success codes.

Change

Use this push button to move a code in the set of success codes back to Specify codes to be modified.

Remove

Use this push button to remove a code from the set of success codes.

Remove all

Use this push button to remove all codes from the set of success codes.