Displaying or printing a list of objects

To display or print a list of objects:

  1. 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
  2. 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'_____________________________________________
                                ___________________________________________________
  3. 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.
  4. 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.
  5. Press Enter.

    FM/Db2 displays or prints the object list panel for the type of object you have specified.

Related tasks

Related references