(DQIR0) Guided Extended Column

 =>
 
 --------------------------------------------------------------------------DQIR0
 DATAQUERY:  GUIDED EXTENDED COLUMN    TABLE:
 -------------------------------------------------------------------------------
 COLUMN NAME                          |    TYPE      LENGTH     DECIMAL
 -------------------------------------------------------------------------------
                                      |
                                      |
                                      |
                                      |
                                      |
                                      |
                                      |
                                      |
                                      |
                                      |
                                      |
                                      |
                                      |
                                      |
 -------------------------------------------------------------------------------
 <PF1> HELP          <PF2>  RETURN     <PF3> NOT USED      <PF4> NOT USED
 <PF5> NOT USED      <PF6>  TEXT       <PF7> NOT USED      <PF8> NOT USED

Description

This SQL Mode panel displays additional Datadictionary attributes not shown on the Guided Query list of column names. Display this panel by selecting the EXTENDED DEF PF key where provided in Guided Query.

Action

When this panel is displayed, you can view the Datadictionary attributes of the column.

Display Fields

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

TABLE:: Datadictionary name of the table whose columns are listed on the panel.

Columns

Refer to the following for explanations of the columns on this panel.

COLUMN NAME

Datadictionary name of the column for the table you selected.

TYPE

See Data Types for explanations of these data types.

N: Numeric (including binary)
F: Float
C: Character
G: Graphics
A: SQL DATE
T: SQL TIME
P: SQL TIMESTAMP

LENGTH

Shows the total length of the column.

DECIMAL

Number of decimal positions.

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.
<PF6> TEXT: Displays text from Datadictionary on TEXT DISPLAY (COLUMN) panel (DQB40).