Executing commands in sequence

Use the Script page of the Command Center notebook to execute several commands in sequence.

Fields and controls

Authorities and privileges

To execute several commands in sequence:

1. Open the Command Center notebook
2. Click the Script tab. The Script page opens.
3. In the Script field, type the DB2 commands or the SQL statements that you want to execute (terminated by semicolons), or select a previously executed command file from the Script History list.

   Note:

   The default statement termination character is the carriage return. You can, however, select the Use statement termination character check box on the General page of the Tools Settings notebook, and specify a different termination character. If you select this check box and do not specify a termination character, the default termination character is the semicolon. (This option is not valid on the Interactive page.) Termination characters are valid only for DB2 scripts. For scripts containing CREATE PROCEDURE statements, a termination character other than a semicolon should be used.

4. Select Script->Execute from the menu selections, or click the icon to execute the commands or statements in sequence.

   Note:

   If you want to execute a single command, rather than all the commands or statements in sequence, highlight the command that you want, and then select Script->Execute from the menu selections, or click the icon.

To terminate a running command, statement, or script in progress, select Script --> Terminate from the menu selections, or click the

icon.

Related information

• Command Center -- Overview
• Creating and saving a command script
• Running an existing command script on the Script page of the Command Center notebook
• Scheduling a job
• Creating an access plan
• Changing the options in the Command Center notebook