Supported commands


This topic describes the supported commands that you can edit and run directly from BMC Workbench for DB2 .

Warning

Note

The HDDL command is available if you have a valid license for the BMC Object Administration for DB2 solution.

Command

Button
(in the Classic console)

Description

DDL

ddl-24.png

Displays the Data Definition Language (DDL) for a selected object

HDDL

hddl-24.png

Displays the Hierarchical Data Definition Language (HDDL) for the selected object and its dependents

DCL

dcl-24.png

Displays the Data Control Language(DCL ) for the selected object

DROP

drop.png

Displays the DROP command for the selected object

BIND

bind-24.png

Displays the BIND command for the selected package, plan, or collection ID

REBIND

rebind-24.png

Displays the REBIND command for the selected package, plan, or collection ID

FREE

free-24.png

Displays the FREE command for the selected package or plan

DISPLAY

display-24.png

Displays the status of the selected object

START

execute-24.png

Displays the START command for a database, table space, table, index, view, or stored procedure

STOP

stop-24.png

Displays the STOP command for a database, table space, table, index, view, or stored procedure

SELECT

g_gud_select-24.png

Displays the SELECT command for a table, alias, or view

INSERT

g_gud_insert-24.png

Displays the INSERT command for a table, alias, or view

UPDATE

g_gud_update-24.png

Displays the UPDATE command for a table, alias, or view

DELETE

g_gud_delete-24.png

Displays the DELETE command for a table, alias, or view



 

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

BMC Workbench for DB2 12.1