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

To generate commands

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

  2. 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.
  3. You can now edit the SQL statement or command, as described in Editing text files in Scratchpad.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*