Panels › (DQT10) Directory of Tables

(DQT10) Directory of Tables

 =>
 PLACE THE CURSOR BY THE DESIRED NAME AND PRESS THE APPROPRIATE PFKEY
 --------------------------------------------------------------------------DQT10
 DATAQUERY:  DIRECTORY OF TABLES              DATADICTIONARY BASE ID: 00016
                                              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
 <PF9> MAINTAIN ROWS

Description

This panel shows the Datadictionary database ID of your personal tables, with the names and descriptions for your authorization ID.

Action

The panel allows you to press a PF key to define a new table, delete a table, maintain a table, or copy definitions to create a new table.

Display Fields

Refer to the following chart for explanations of the display fields intended to contain variable data.

DATADICTIONARY BASE ID:

Shows the ID of the database where your personal tables are stored.

Entry Fields

Refer to the following chart for valid entries in the fields on this panel. Use the Tab and arrow keys to move the cursor. To change an entry, write or space over it. When entries are complete, press Enter or a valid PF key.

Columns

Refer to the following for a discussion of each column on this panel.

TABLE NAME

Shows the names of all tables in your personal database.

DESCRIPTION

The description assigned the table at creation.

PF Keys

The following lists the PF keys for this panel, with a brief description of each function.

<PF1> HELP

Displays Help information about the current panel.

<PF2> RETURN

Exits the current panel.

<PF3> CREATE

Creates a new personal table.

<PF4> DROP

Drops the table indicated by the cursor.

<PF5> DISPLAY

Shows the definitions for the table indicated by the cursor.

<PF6> INSERT ROWS

Adds data to the table indicated by the cursor.

<PF7> BACKWARD

Scrolls list backward one page.

<PF8> FORWARD

Scrolls list forward one page.

<PF9> MAINTAIN ROWS

Finds data in the table indicated by the cursor. Changes data if needed.