Executing single DB2 commands or SQL statements

Use the Interactive page of the Command Center notebook to execute single DB2 commands or SQL statements.

The Interactive page is intended for executing single commands. To run several commands in sequence, use the Script page.

Fields and controls

Authorities and privileges

To execute a command:

1. Open the Command Center notebook
2. Click the Interactive tab. The Interactive page opens.
3. Select the database on which you wish to execute the command in the Database connection field. To select the database, click: and select the database from the Select Database window.
4. In the Command field, type the DB2 command or the SQL statement that you want to execute (terminated by a semicolon), or select a previously executed command or statement from the Command history list.
5. Select Interactive --> Execute or click to execute the command or statement.

To terminate a running command, statement, or script in progress, select Interactive --> 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