(DQHS0) Guided Extended Key

 =>
 
 --------------------------------------------------------------------------DQHS0
 DATAQUERY:  GUIDED EXTENDED KEY       TABLE:
 -------------------------------------------------------------------------------
   KEY NAME:
 ------------------------------------------------------------------------------
   COLUMN NAMES                         | TYPE  LEN    DEC  SIGN   OCC  CLASS
 ---------------------------------------|---------------------------------------
                                        |
                                        |
                                        |
                                        |
                                        |
                                        |
                                        |
                                        |
                                        |
                                        |
                                        |
                                        |
 -------------------------------------------------------------------------------
 <PF1> HELP          <PF2>  RETURN     <PF3> NOT USED      <PF4> NOT USED
 <PF5> TEXT KEY      <PF6>  TEXT COL   <PF7> BACKWARD      <PF8> FORWARD

Description

In DQL Mode, this panel displays the Datadictionary description of any key shown on the Guided Query list containing key names. Display this panel by selecting the EXTENDED DEF PF key on panels where it is displayed as an option.

Action

When this panel is displayed, you can view the Datadictionary descriptions of the key.

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 keys and columns are listed on the panel.
KEY NAME:: Datadictionary description of the key name you have selected.

Columns

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

COLUMN NAMES

Datadictionary name of the key and columns in the key you selected.

TYPE

One of the following:

C: Character
N: Numeric (including binary)
E: Extended floating-point
S: Short floating-point
G: Graphics
T: Bit for PL/1
H: Hex
Y: Double character
K: Kanji
Z: Double character mixed
L: Long floating-point

LEN

Number of positions.

DEC

Number of positions after the decimal.

SIGN

If a numeric key/column, + or - sign.

OCC

Number of occurrences, if a repeating key/column.

CLASS

Type of column:

C: Compound for group keys/columns.
S: Simple for single keys/columns.
F: Filler for place-holder keys/columns.

Reported as Numeric

Packed, zoned, and half word binary types and lengths are reported as numeric and may not indicate an appropriate match for RELATED BY statements.

DATE, TIME, or TIMESTAMP

When creating queries, do not include columns defined as data types DATE, TIME, or TIMESTAMP. These data types are reserved for SQL Mode queries. These data types are listed as character types on Extended Column Display panels because SQL Mode queries return character-type data.

To test a column that is suspected of being one of these types before selecting it for a DQL Mode query, follow these steps.

Look at the length of the column. DATE length is always 10, TIME is always 8, and TIMESTAMP is always 26.
If the data type is suspect, create a query that finds one row and PRINT the output.

PF Keys

The following lists the PF keys for this panel, with a brief description of each function.

<PF1> HELP: Displays Help information.
<PF2> RETURN: Exits the current panel.
<PF5> TEXT KEY: Displays text for the key.
<PF6> TEXT COL: Displays Datadictionary text.
<PF7> BACKWARD: Scrolls the list backward.
<PF8> FORWARD: Scrolls the list forward.