Object List Utility panel

You use the Object List Utility panel to specify details about the objects you want to list or print.

Panel and field definitions

  Process   Options   Utilities   Help
 ──────────────────────────────────────────────────────────────────────────────
 FM/Db2 (DFG2)                Object List Utility

    blank Display object list                 P Print object list

 Object Identification Criteria:
    Location  . . . . . . .                     Enter * for list
    Owner . . . . . . . . .                   +
    Name  . . . . . . . . .                                                   +
    Database/collect/schema                                                   +

 Additional Selection Criteria:
  . . . . . . . . . . . . . . . . . . . . . . . Enter * to list catalog columns
    Column  . . . . . . . .                               
    Operator  . . . . . . .            
    Value . . . . . . . . .                                                   +

 Processing Options:
    Object Type                                Enter ? to list all object types
    3    1. Database          8.  Package            15. Trigger        
         2. Table space       9.  Collection         16. Storage group  
         3. Table/view/alias  10. DBRM               17. Sequence       
         4. Index             11. Schema             18. Role           
         5. Column            12. Distinct type      19. Trusted context
         6. Synonym           13. Function                              
         7. Plan              14. Stored procedure                      

    Enter "/" to select option
    /  Confirm object drop

 When the object list is displayed, enter either:
   "?" on the object list command field for the command prompt panel, or
   "=" execute the previous command.
 Command ===>                                                                  
  F1=Help      F2=Split     F3=Exit      F4=Expand    F7=Backward  F8=Forward
  F9=Swap     F10=Left     F11=Right    F12=Cancel
Location
The location of the objects you want listed
Owner
The name of the person who created the Db2® object
Name
The name of the Db2® object
Database/collect/schema
The name of a database, a collection, or a schema
Column
Name of column in the relevant Db2® system catalog table
Operator
A valid SQL operator
Value
The value to be compared with the contents of the column
Object Type
The type of Db2® object that you want listed. The default is 3 (Tables).
Confirm object drop
Indicates if you want FM/Db2 to display a confirmation panel each time you enter a DR(op) command against an object

Parent panels

Child panels

To display this panel… Use/do this
Databases panel Object Type 1
Table Spaces panel Object Type 2
Tables, Views and Aliases panel Object Type 3
Indexes panel Object Type 4
Columns panel Object Type 5
Synonyms panel Object Type 6
Application Plans panel Object Type 7
Application Packages panel Object Type 8
Collections panel Object Type 9
Database Request Modules panel Object Type 10
Schemas panel Object Type 11
Distinct Types panel Object Type 12
Functions panel Object Type 13
Stored Procedures panel Object Type 14
Triggers panel Object Type 15

Related tasks