Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Command Center for Db2 13.2

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

QuickCourseArrow.png

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

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.


    QuickCourseArrow.png

    For more information, view the Quick Course Workbench for DB2 - Executing DB2 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.


Classic console

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

    QuickCourseArrow.png

    For more information, view the Quick Course Workbench for DB2 - Executing DB2 Commands.

  2. 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.
  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*