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.