Displaying or printing a list of objects
To display or print a list of objects:
- Specify object identification criteria to identify the objects
you want listed:
- Location
- The location of the objects you want listed.
Leave this field blank if the objects you want listed are at your current location. Otherwise, type the full name of the remote location, an asterisk (*) to display all available remote locations, or a pattern using wildcard characters. If you specify an asterisk on its own or a pattern, FM/Db2 displays a selection list showing the locations that match the input specification.
To select the location you want, type
S
against the required entry and press Enter. - Owner
- The name of the person who created the Db2® object.
To select objects regardless of their owner, leave this field blank. Otherwise, to restrict the list of objects by owner, type either the full name of the owner or a pattern using wildcard characters. If this entry field is not blank, FM/Db2 limits the objects listed to those matching the owner selection criteria you specify.
- Name
- The name of the Db2® object.
To select objects regardless of their name, leave this field blank. Otherwise, to restrict the list of objects by name, type either the full name of the object or a pattern using wildcard characters. If this entry field is not blank, FM/Db2 limits the objects listed to those matching the name selection criteria you specify.
- Database/collect/schema
- The name of a database, a collection, or a schema. The name can be a full name or a pattern.
This name is used to restrict the list of objects to only those objects that are in the specified
database, collection, or schema. If you specify a pattern, the list of objects includes any objects
that are included in a database or collection or schema whose name matches the pattern
specification. How FM/Db2 uses this field depends upon the type of object being listed as specified using the Object Type (see step 3):
- Object type
- Field use
- Database
- Not allowed
- Table space
- Used as database name
- Table, view, or alias
- Used as database name
- Index
- Used as database name
- Column
- Used as database name
- Synonym
- Used as database name
- Plan
- Not allowed
- Package
- Used as collection name
- Collection
- Not allowed
- DBRM
- Not allowed
- Schema
- Used as schema name
- Distinct type
- Used as schema name
- Function
- Used as schema name
- Stored procedure
- Used as schema name
- Trigger
- Used as schema name
- Specify any additional selection criteria to further restrict the objects to be listed by coding
a simple SQL SELECT
where clause
that specifies a column in the appropriate Db2® system catalog table.- Column
- Name of column in the relevant Db2® system catalog table. To list the columns in the appropriate Db2® system catalog table, enter an asterisk (*).
- Operator
- A valid SQL operator.
- Value
- The value to be compared with the contents of the column.
For more information about SQL statements, see the DB2 for z/OS SQL Reference.
For example, to restrict a list of columns to only those columns with a data type of DATE, specify the following values:Additional Selection Criteria: Column . . . . . . . . COLTYPE____________ Enter * to list catalog columns Operator . . . . . . . =_________ Value . . . . . . . . . 'DATE'_____________________________________________ ___________________________________________________
- Nominate the type of object you want listed, and other
options to apply to processing of the listed objects.
- Object Type
- Specify the type of Db2® object
that you want listed. The numeric indicator for each object type is
shown on the Object List Utility panel. This input field is mandatory,
but defaults to
3
(Table/view/alias). - Confirm Db2® Object Drop
- Indicates if you want FM/Db2 to display a confirmation panel each
time you enter a DR(op) command against an object.
- /
- Display a confirmation panel if a DROP command is entered against an object. This is the default setting.
- (blank)
- If a DROP command is entered against an object, issue the command without displaying a confirmation panel.
- Specify if you want to display or print the list of objects:
- To display a list of objects, leave the command line blank.
- To print a list of objects, enter
P
on the command line.
- Press Enter.
FM/Db2 displays or prints the object list panel for the type of object you have specified.
Related tasks
Related references