Panels › (DQB90) Column Display (from Editor)

(DQB90) Column Display (from Editor)

 =>
 TO ORDER THE COLUMNS, ENTER A NUMBER IN FRONT OF EACH ONE
 --------------------------------------------------------------------------DQB90
 DATAQUERY:  COLUMN DISPLAY                    DICTIONARY DATABASE ID:
 -------------------------------------------------------------------------------
  TABLE NAME:                                   DB NAME:       DB ID:
 -------------------------------------------------------------------------------
             COLUMN NAME               |             DESCRIPTION
 -------------------------------------------------------------------------------
 ____                                  |
 ____                                  |
 ____                                  |
 ____                                  |
 ____                                  |
 ____                                  |
 ____                                  |
 ____                                  |
 ____                                  |
 ____                                  |
 ____                                  |
 -------------------------------------------------------------------------------
 <PF1> HELP          <PF2>  RETURN     <PF3> NOT USED      <PF4> DISPLAY KEYS
 <PF5> EXTENDED DEF  <PF6>  TEXT       <PF7> BACKWARD      <PF8> FORWARD

Description

This panel is displayed when you press the DISPLAY COLUMNS PF key from the Editor panel. This panel allows input or numbers to the left of the displayed column names. The numbers you enter indicate that the column name is to be copied back to the query text being edited and the desired order for the selected columns within the query text.

Anyone authorized to edit a query can use this panel.

Action

Enter a number to indicate list order in the selection column for each column name you want displayed on the Editor panel.

Display Fields

Refer to the following for explanations of the display fields intended to 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 column names are displayed on this panel.

DB NAME:

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

DB ID:

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

Columns

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

COLUMN NAME

Column names for the table (indented).

DESCRIPTION

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

Entry Fields

Refer to the following chart 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.

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

Returns to the Editor panel with any selected column names.

<PF4> DISPLAY KEYS

Displays keys for the current table.

<PF5> EXTENDED DEF

Displays the extended definitions of listed columns.

<PF6> TEXT

Displays query text.

<PF7> BACKWARD

Scrolls to previous panel, if any.

<PF8> FORWARD

Scrolls to next panel, if any.