Listing objects and Db2 tables

You can create a list of Db2 table owners, Db2 tables, QMF queries, QMF procedures, or all objects and tables using the LIST command or by selecting an option from the List menu.

About this task

The list display is a scrollable table display that shows further information about each item. From the list you can select items to display more detailed information or to browse table or object data.

The LIST command accepts up to two optional parameters: a type parameter and an object argument parameter. If no parameters are entered, then a prompt panel is displayed. If no parameters are entered on the prompt panel, then a default list of all QMF objects and Db2 tables visible to you will be displayed. Only objects that are visible to your authorization id can be listed.

  • The type parameter determines the type of object to list. Valid values are OWNERS, QUERIES, PROCS, PROCEDURES, TABLES or ALL. A one-character abbreviation of any of these values is also valid.
  • The argument parameter determines the list argument. Use the QMF pattern characters to specify a subset of matching objects of the type specified in the type parameter. The ALL parameter specifies that any owner and object name are included. This is also the default if an argument parameter is not specified. For a list of table owners, only pass one qualifier.
Note: When the object name is unqualified, the list operation uses the default owner value found in the DSQEC_LIST_OWNER global variable. If this is blank, then the value of DSQAO_CONNECT_ID is used instead. The default initial list sort order follows the current value of the DSQDC_LIST_ORDER global variable. The current values of DSQEC_LIST_OWNER and DSQDC_LIST_ORDER can be updated using the QMF Enhanced Editor Settings dialog.

Procedure

  1. Enter a LIST command from the Enhanced Editor command line or select a list option from the List menu.

    For example:

    • The command below lists all Db2 table owners starting with A.
      Command ===> list owners A%
    • The command below lists all QMF SQL queries.
      Command ===> list q
    • The command below lists all Db2 tables belonging to the owner boyd.
      Command ===> list tables boyd.%
    • The command below lists all QMF objects and Db2 tables belonging to you that start with B.
      Command ===> list all B%
  2. Press END to cancel the command.