Displaying Database Names and Structures › Directory of Tables

Directory of Tables

If you want to know which tables you are authorized to access, you can display a panel like this:

SQL Mode

 =>
 PLACE THE CURSOR ON THE DESIRED NAME AND PRESS THE APPROPRIATE PFKEY
 --------------------------------------------------------------------------DQDA0
 DATAQUERY:  DIRECTORY OF TABLES   START WITH: --------------------------------
 -------------------------------------------------------------------------------
       OBJECT NAME                  |     DESCRIPTION
 -------------------------------------------------------------------------------
VELA-TABLE_NAME                     |  DESCRIPTIVE TEXT BY CREATOR
LABBE-TABLE_NAME                    |  MORE DESCRIPTIVE TEXT
                                    |
                                    |
                                    |
                                    |
                                    |
                                    |
                                    |
                                    |
                                    |
                                    |
                                    |
                                    |
 -------------------------------------------------------------------------------
 <PF1> HELP           <PF2> RETURN          <PF3> DISPLAY COLUMNS <PF4> NOT USED
 <PF5> NOT USED     <PF6> DISPLAY TEXT <PF7> BACKWARD            <PF8> FORWARD

Note: The names displayed are the SQL names of tables or names of views or synonyms for the currently used authid.

DQL Mode

 =>
 PLACE THE CURSOR ON THE DESIRED NAME AND PRESS THE APPROPRIATE PFKEY
 --------------------------------------------------------------------------DQAF0
 DATAQUERY:  DIRECTORY OF TABLES             DATADICTIONARY BASE ID: 002
                                   START WITH: --------------------------------
 -------------------------------------------------------------------------------
       TABLE  NAME                |STATUS|     DESCRIPTION
 -------------------------------------------------------------------------------
   AGGREGATE                      |  O   | DD ENTITY FILE
   ALIAS                          |  C   | DD ENTITY ALIAS
   AREA                           |  O   | DD ENTITY AREA
   ARENDT-FIELDS                  |  O   |
   ARENDT-INVPERF                 |  O   |
   AUTHORIZATION                  |  O   | AUTHORIZATION-ENTITY-TYPE-RECORD
   BAHR-CHARLIE                   |  O   |
   BAHR-EMP-DB                    |  O   |
   BAHR-EMPLOYEE                  |  O   |
   BAHR-JOINED-TABLE              |  O   |
   BAHR-MY-TABLE                  |  C   |
   BAHR-PAYROLL                   |  O   |
   BEN-ACCTBLE                    |  O   |
 -------------------------------------------------------------------------------
 <PF1> HELP          <PF2> RETURN       <PF3> DISPLAY COLUMNS <PF4> DISPLAY KEYS
 <PF5> DISPLAY ALL   <PF6> DISPLAY TEXT <PF7> BACKWARD        <PF8> FORWARD

The table names shown on this panel are CA Datacom Datadictionary entity names. The list shows tables you can access, including personal tables you create. DESCRIPTION provides a brief description of the table contents.