Generating a command

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

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

To generate commands

New BMC Workbench console

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 command buttons 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 BMC Workbench 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.