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*