Skip to Content

Commands to access SQL

Related topics

Integrating Catalog Manager with the BMC Explain component

Catalog Manager

 enables you to issue simple line commands to access SQL, as follows:

  • Issue the BMCEXPLORE command to explain a DBRM, package, or plan.

    Using the BMCEXPLORE command

    CatMngr_BMCExploreCmd.png

  • Issue the DESCRIBE and GET commands to explain an SQL statement that is stored in a DBRM or a package.

    Using the DESCRIBE and GET commands

    CatMngr_DESCRIBE-GET.png

  • Issue the ANALYZE command to explain or edit a DML statement from the Catalog Manager SQL_Table.

    Using the ANALYZE command

    CatMngr_Analyze.png

This section contains the following topics:

 

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

BMC AMI Catalog Manager for Db2 13.1