Panels › (DQHR0) Extended Column Display

(DQHR0) Extended Column Display

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

Description

In DQL Mode, this 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 for explanations of the display field 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

One of the following:

C

Character

E

Extended floating-point

G

Graphics

H

Hex

K

Kanji

L

Long floating-point

N

Numeric (including binary)

S

Short floating-point

T

Bit for PL/1

Y

Double character

Z

Double character mixed

LEN

Number of positions.

DEC

Number of positions after the decimal.

SIGN

If a numeric column, Y (has a + or - sign) or N (is unsigned).

OCC

Number of occurrences. 1 indicates column is not repeating.

CLASS

Type of column:

C

Compound for group columns.

S

Simple for single columns.

F

Filler for place-holder 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.

1. Look at the length of the column. DATE length is always 10, TIME is always 8, and TIMESTAMP is always 26.
2. 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 about the current panel.

<PF2> RETURN

Exits the current panel.

<PF6> TEXT

Displays text from Datadictionary on TEXT DISPLAY (COLUMN) (DQB40) panel.

<PF7> BACKWARD

Scrolls the list backward.

<PF8> FORWARD

Scrolls the list forward.