(DQDA0) Directory of Tables (SQL Mode)

Panels › (DQDA0) Directory of Tables (SQL Mode)

(DQDA0) Directory of Tables (SQL Mode)

=>
Place the cursor on the desired name and press the appropriate PFkey
--------------------------------------------------------------------------DQDA0
DATAQUERY:  DIRECTORY OF TABLES   START WITH: ________________________________
-------------------------------------------------------------------------------
      OBJECT NAME                  |     DESCRIPTION
-------------------------------------------------------------------------------
                                   |
                                   |
                                   |
                                   |
                                   |
                                   |
                                   |
                                   |
                                   |
                                   |
                                   |
                                   |
                                   |
                                   |
-------------------------------------------------------------------------------
<PF1> HELP         <PF2> RETURN       <PF3> DISPLAY COLUMNS <PF4> NOT USED
<PF5> NOT USED     <PF6> DISPLAY TEXT <PF7> BACKWARD        <PF8> FORWARD

Description

This SQL Mode panel displays a list of database tables you are authorized to access with a query or dialog.

Action

View the list to determine which tables you want to search with your query or dialog. To display a list of columns or the description of any table, position the cursor on its name and press the appropriate PF key.

Entry Fields

Refer to the following for valid entries in the field 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.

Field	Required?	Valid Entries	Default
START WITH:	N	First 1-15 letters of an item name to move to the top of the display. Name may be partial or complete.	No default

Columns

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

OBJECT NAME: Lists tables you are authorized to access.
DESCRIPTION: A description of the table.

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 panel.
<PF3> DISPLAY COLUMNS: Displays a list of columns for the table indicated by cursor position.
<PF6> DISPLAY TEXT: Displays the textual description for the table indicated by cursor position.
<PF7> BACKWARD: Displays a previous panel, if any.
<PF8> FORWARD: Displays next panel, if any.