Previous Topic: (DQAD0) LIST COMMAND Prompt (SQL Mode)Next Topic: (DQAK0) Directory Selection (SQL)


(DQAF0) Directory of Tables

=> Place the cursor on the desired name and press the appropriate PFkey --------------------------------------------------------------------------DQAF0 DATAQUERY: DIRECTORY OF TABLES DATADICTIONARY BASE ID: 444 START WITH: ________________________________ ------------------------------------------------------------------------------- TABLE NAME |STATUS| DESCRIPTION ------------------------------------------------------------------------------- | | | | | | | | | | | | | | | | | | | | | | | | | | ------------------------------------------------------------------------------- <PF1> HELP <PF2> RETURN <PF3> DISPLAY COLUMNS <PF4> DISPLAY KEYS <PF5> DISPLAY ALL <PF6> DISPLAY TEXT <PF7> BACKWARD <PF8> FORWARD

Description

This 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. Note whether the table is open (O), as you can only query an open table. To display a list of columns or keys or the description of any table, position the cursor on its name and press the appropriate PF key.

Display Fields

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

DATADICTIONARY BASE ID

The database ID of the data dictionary containing the tables you can access.

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.

TABLE NAME

Lists tables you are authorized to access.

STATUS

Lists status of each table:

O

Open and can be queried.

C

Closed and cannot be queried.

D

Disabled. Must be enabled in the Datadictionary before it can be accessed.

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.

<PF4> DISPLAY KEYS

Displays a list of keys for the table indicated by cursor position.

<PF5> DISPLAY ALL

Displays a list of keys and columns for the table indicated by the 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.