Generating a command

Use the following procedure to generate a command for a selected object. The generated command is displayed in Scratchpad.

Related topic

Working with commands

For more information, view the Quick Course Workbench for DB2 - Generating DML.

To generate commands

In the DB2 Navigator perspective, select the required object or objects ( up to five).
For more information, see Navigating to an object.
The Commands drop-down list displays valid commands for the selected objects. See Supported commands.

For more information, view the Quick Course Workbench for DB2 - Executing DB2 Commands.
Select the relevant command from the Commands drop-down list.
The Scratchpad perspective opens to display the SQL statement in the Command Text tab. If you selected multiple objects, the SQL statements or commands are displayed consecutively in the Scratchpad.
You can now edit the SQL statement or command, as described in Editing text files in Scratchpad.

Classic console

In the DB2 Navigator perspective, select the required object or objects ( up to five).
For more information, see Navigating to an object.
The command tool bar displays valid command buttons for the selected objects. See Supported commands.

For more information, view the Quick Course Workbench for DB2 - Executing DB2 Commands.
Click the relevant command button.
The Scratchpad perspective opens to display the SQL statement in the Command Text tab. If you selected multiple objects, the SQL statements or commands are displayed consecutively in the Scratchpad.
You can now edit the SQL statement or command, as described in Editing text files in Scratchpad.