SQL statements

Db2 Admin Tool can issue, build, and run SQL statements.

This information describes how to use Db2 Admin Tool to perform the following tasks:

  • Issue dynamic SQL statements from your screen, from a data set, or from program file
  • Build and run SQL SELECT, INSERT, UPDATE, and DELETE statements interactively by using line commands
  • Run the following SQL statements by entering required parameters: CREATE, DROP, LABEL ON, COMMENT ON, GRANT, and REVOKE

    The two panels for this function are also used from the system catalog panels, where they are shown when a line command is issued against an object. When invoked in this way, the object names contain the object name from the catalog.