Panels › (DQB10) Keys and Columns Display

(DQB10) Keys and Columns Display

 =>
 PLACE THE CURSOR ON THE DESIRED NAME AND PRESS THE APPROPRIATE PFKEY.
 --------------------------------------------------------------------------DQB10
 DATAQUERY:  KEYS AND COLUMNS DISPLAY                DICTIONARY DATABASE ID:
 -------------------------------------------------------------------------------
  TABLE NAME:                                        DB NAME:       DB ID:
 -------------------------------------------------------------------------------
   KEY NAMES                                         |  DESCRIPTION
       COLUMN NAMES                                  |
 -------------------------------------------------------------------------------
key-name                                             |
high-order-column-name                               |
key-name                                             |
key-name                                             |
    column-name                                      |
    column-name                                      |
    column-name                                      |
                                                     |
                                                     |
                                                     |
 -------------------------------------------------------------------------------
 <PF1> HELP          <PF2>  RETURN    <PF3> DISPLAY COLUMNS   <PF4> DISPLAY KEYS
 <PF5> NOT USED      <PF6>  TEXT      <PF7> BACKWARD          <PF8> FORWARD

Description

This panel displays the names and descriptions of keys and columns. You can get this panel by using the DISPLAY ALL PF key on panels where it is shown as an option. You can also type DISPLAY table-name in the command line to display this panel.

Action

You can view names of keys and columns for a specific table. To find a key name, use a name that is not indented. To find a column name, choose an indented object that is not also un-indented.

Display Fields

Refer to the following for explanations of the display fields at the top of this panel that can contain variable data.

DICTIONARY DATABASE ID:

The DATACOM-ID of the current Datadictionary database containing the definitions for this table.

TABLE NAME:

Name of the table whose key and column names are displayed on this panel.

DB NAME:

The DATACOM-ID of the table whose key and column names are displayed on this panel.

DB ID:

The DATACOM-ID of the database containing the table whose key and column names are displayed on this panel.

Columns

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

KEY NAMES/ COLUMN NAMES

Lists key and first column name of each key. Other column names are indented.

DESCRIPTION

Lists description, if any, of key or column named at left.

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> DISPLAY COLUMNS

Displays the COLUMN DISPLAY panel (DQB20).

<PF4> DISPLAY KEYS

Displays the KEY DISPLAY panel (DQB50).

<PF6> TEXT

Displays the TEXT DISPLAY (Key) panel (DQB70) for the selected key or column.

<PF7> BACKWARD

Scrolls the list backward.

<PF8> FORWARD

Scrolls the list forward.