Displaying Personal Table Definitions › Listing Personal Tables

Listing Personal Tables

Selecting PDB from the Main Menu displays a list of all tables with your authorization ID on the DIRECTORY OF TABLES (DQT10) panel. The names displayed may be slightly different when they are listed on a directory listing, since CA Datacom Datadictionary sometimes adjusts names to make them unique. A table name is made up of the creator's authorization ID and the assigned table name. If you do not see a table name listed that you need, see your CA Dataquery Administrator.

Use the DIRECTORY OF TABLES panel to create, delete, display or maintain a personal table.

Panel

The following is an example of the DIRECTORY OF TABLES (DQT10) panel.

 =>
 PLACE THE CURSOR BY THE DESIRED NAME AND PRESS THE APPROPRIATE PFKEY
 --------------------------------------------------------------------------DQT10
 DATAQUERY:  DIRECTORY OF TABLES              DATADICTIONARY BASE ID: 002
                                              START WITH:   __________________
 -------------------------------------------------------------------------------
       TABLE NAME                     | DESCRIPTION
 -------------------------------------------------------------------------------
   ORG                                | ORGANIZATION INFORMATION
   STAFF                              | STAFF DATA
   PERSONNEL                          | EMPLOYEE INFORMATION
   RETIREMENT                         | RETIREMENT PLANNING
   BENEFITS                           | BENEFIT RECORDS
   QUOTAS                             | QUOTA PER SALES REP
   CLIENTS                            | CLIENT NAMES AND ADDRESSES
   BUDGET                             | DEPARTMENTAL BUDGET
   COMPETITORS                        | COMPETITOR PRODUCT INFORMATION
                                      |
                                      |
                                      |
 - LAST PAGE -------------------------------------------------------------------
 <PF1> HELP           <PF2> RETURN       <PF3> CREATE         <PF4> DROP
 <PF5> DISPLAY        <PF6> INSERT ROWS  <PF7> BACKWARD       <PF8> FORWARD

The DIRECTORY OF TABLES panel displays the CA Datacom Datadictionary database ID containing your personal tables. It lists the names of all of the personal tables for your authorization ID with a description of each one (if a description was entered). The PF key menu at the bottom of the panel allows selection of other Personal Database features.

Operation

The following shows functions and the actions required to perform these functions, when using the DIRECTORY OF TABLES panel.

Move a table name to the top of the list.

Enter the first unique characters of a table name in the Start With field and press Enter.

To scroll the list forward

Press <PF8> FORWARD.

To scroll the list backward

Press <PF7> BACKWARD.

Other Things You Can Do

The PF keys at the bottom of the DIRECTORY OF TABLES (DQT10) panel also allow access to other features.

Define a new personal table.

Press <PF3> CREATE. See Defining a New Personal Table for instructions.

Delete an existing personal table and its data.

Press <PF4> DROP with the cursor on a table name. See Deleting a Table.

See column definitions for a specific personal table.

Press <PF5> DISPLAY with the cursor on a table name. See Display a Personal Table Definition for an understanding of the panel.

See Copying a Personal Table Definition for instructions on copying the resulting definition.

See Maintaining Personal Databases on maintaining data within the table whose definition you display.

Add a row to a personal table.

Press <PF6> INSERT ROWS with the cursor on a table name. Maintaining Personal Databases tells how to add, update, and delete rows in the table selected.