Change/View Batch Step -- Fields and controls

Use the Change/View Batch Step notebook to edit or view the properties of a batch step.

In view mode, the properties cannot be modified.

" " Script page
" " Execution Target page
" " Success Codes page
" " OK
" " Cancel



Script page

" " File name
" " Description
" " Type
" " Import
" " Script contents
" " Parameterized
" " Statement termination character

" " File name

Use this field to specify the file name for the script to be used in the batch step.

" " Description

Use this field to specify a description for the script. The description can be a maximum of 128 characters.

" " Type

Select a radio button to specify the type of execution target against which the script will execute:

DB2 command script for database
The script will execute against a DB2 database.

DB2 command script for instance
The script will execute against a DB2 instance.

Operating system script
The script will execute against an operating system, or an object managed by the operating system.

" " Import

Click this push button to import one or more scripts from the Import Script window. The scripts that you import will be appended to any existing script.

" " Script contents

Use this field to type the script. If you import a script, its contents will be displayed in this field.

" " Parameterized

Select this check box if the script is parameterized.

" " Statement termination character

Use this field to indicate the statement continuation character that you want to use for scripts that execute against DB2 instances or DB2 databases.

Leave this field blank to use the new line character as the statement termination character, and the back slash (\) as the continuation character.

This field does not apply for operating system scripts.



Execution Target page

" " Target alias
" " Authentication

" " Target alias

Use this field to specify the target alias for a DB2 database or DB2 instance script. Use the ... push button to display the list of targets that are already stored in the Satellite Administration Center, then select one.
Note:A target alias is not required for operating system scripts.

DB2 instance script
Specify the alias of the DB2 instance that the script will execute against.

DB2 database script
Specify the alias of the DB2 database that the script will execute against.

" " Authentication name

Use this field to specify the name of the authentication credentials to be associated with a DB2 database or DB2 instance script. Use the ... button to display a list of authentication credentials that are already stored in the Satellite Administration Center.
Note:Authentication credentials are not required for operating system scripts.

Success Code Set page

" " Success codes set name
" " Description
" " Specify codes
" " Add
" " Change
" " Remove
" " Remove All

" " Success codes set name

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

" " Description

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

" " 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 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.