Space announcement This documentation space provides the same content as before, but the organization of the content has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

DB2 Table/View List (5.5.1)

Related Tpoics

Quick-Reference

Customizing-after-installation

The DB2 Table/View List screen (5.5.1) displays a list of Db2 tables and views that you are authorized to access. The list is in alphabetical order by creator.

Access this screen by typing 1 on the DB2 Easy Query Menu (5.5) or as described in Transferring Between Screens.

DB2 Table/View List Screen (5.5.1)

---------------------------- DB2 TABLE/VIEW LIST (5.5.1) ------------------C024
 COMMAND ===>                                                   SCROLL ===> CSR
 MODULE:          CSECT:

                                                            ROW     1 OF 207

LIMIT LIST TO:   CREATOR:  *        TABLE/VIEW:  *                  TYPE: *
                 DATABASE: *        TABLESPACE:  *

 LINE COMMANDS: Q (SQL Easy Query)  S (Select)

 CMD   CREATOR      TABLE/VIEW NAME    TYPE    DATABASE   TABLESPACE
---   --------   ------------------   -----   --------   ----------
  _    CIBER01    PLAN_TABLE           TABLE   CBV2CLAS   PLANRTAB
  _    CWS060     EMPTESTX             TABLE   CW060V2    CW060TS
  _    CWS060     EMPTEST1             TABLE   CW060V2    CW060TS
  _    CWS060     FIRSTTAB             TABLE   CW060V2    CW060TS
  _    CWS060     TRANSTEC             TABLE   CW060V2    TRANSTEC
  _    CWS097     REPORT               TABLE   CWS097V2   CWS097TS
  _    CWXAAD2    AATABBETA            TABLE   CWAADV2    CWAADTS
  _    CWXAAD2    AATABDEV             TABLE   CWAADV2    CWAADTS
  _    CWXAAD2    AATAB222             TABLE   CWAADV2    CWAADTS
  _    CWXAAD2    AATAB553             TABLE   CWAADV2    CWAADTS
  _    CWXAAD2    AATAB554             TABLE   CWAADV2    CWAADTS

Input Fields

Global Parameters Used to Initialize Defaults

The input fields in the LIMIT LIST TO area of the DB2 Table/View List screen are initialized based on the values of the Code Debug CICS global parameters listed in following table. For a complete description of Code Debug’s global parameters, see Code Debug CICS Advanced Configuration space.

Code Debug Global Parameters for DB2 Table/View List Screen

DB2 Table/View List Screen Field

Global Parameter
Used to Initialize Field

CREATOR

FILE_UTILITY_DB2_CREATOR_LIMIT

TABLE/VIEW

FILE_UTILITY_DB2_TABLE_LIMIT

TYPE

FILE_UTILITY_DB2_TYPE_LIMIT

DATABASE

FILE_UTILITY_DB2_DATABASE_LIMIT

TABLESPACE

FILE_UTILITY_DB2_TABLESPACE_LIMIT

LIMIT LIST TO Area

Limits the list to only tables and views that you want to see. Db2 security limits the list to tables and views that you are allowed to access with your user ID. Fields can be used in combination to create selection criteria for the list of tables and views.

The asterisk (*) is used as a generic matching character; any positions starting at the asterisk and continuing through the end of the string are assumed to match. An asterisk in position 1 selects all entries for that field.

Important

The limits established in these fields are applied only after acquiring a complete list of tables/views you are allowed to access. This technique provides faster access to a limited list than can be provided by Db2 alone.

CREATOR

Limits the displayed list to tables created by specified users.

TABLE/VIEW

Limits the displayed list to specified tables and views.

TYPE

Limits the displayed list to the specified type. Valid values are TABLE, VIEW, and asterisk (*).

DATABASE

Limits the displayed list to tables and views residing in the specified Db2 databases.

TABLESPACE

Limits the displayed list to tables and views residing in the specified Db2 tablespaces.

CMD

Line command entry field. Valid entries are:


    • Q (Query): Selects a Db2 table for EASY QUERY. This command transfers you to the DB2-Build-SQL-Easy-Query-5-5-2 screen so that you can customize the query for data in the table. The Q line command is not allowed for views.
    • S (Select): Selects a Db2 table or view when you want to see all columns. This command transfers you to the DB2-Browse-Result-Table-5-5-4 screen so that all columns in the table or view are displayed. If authorized, you may edit data on this screen if TABLE is in the TYPE field. The result table from a view may not be edited. You may also position the cursor anywhere on a line that defines a table or view and press the SELECT key.

Output Fields

ROW xxxxx OF yyyyy

Displays the current top row (xxxxx) within the total rows (yyyyy) of columns from the table that are available for display on this screen.

CREATOR

Name of the creator of the Db2 table or view obtained from the Db2 catalog.

TABLE/VIEW NAME

Name of the Db2 table or view obtained from the Db2 catalog.

TYPE

Indicates the type of information being displayed:

  • TABLE: Indicates the Db2 table that contains data that may be displayed and updated.
  • VIEW: Indicates how the Db2 table is to be displayed, rather than the actual data. Data from views cannot be updated.

DATABASE

Name of the Db2 database where the table resides.

TABLE SPACE

Name of the Db2 table space where the table resides.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*