Panels › (DQBC0) Extended Column Display

(DQBC0) Extended Column Display

=>
Place the cursor on the desired name and press the appropriate PFkey.
--------------------------------------------------------------------------DQBC0
DATAQUERY:  EXTENDED COLUMN DISPLAY   TABLE:
-------------------------------------------------------------------------------
  COLUMN NAME                        |TYPE    LEN   DEC SIGN  NULL    OCC CLASS
-------------------------------------------------------------------------------
                                     |
                                     |
                                     |
                                     |
                                     |
                                     |
                                     |
                                     |
                                     |
                                     |
                                     |
                                     |
                                     |
                                     |
-------------------------------------------------------------------------------
<PF1> HELP          <PF2>  RETURN     <PF3> NOT USED      <PF4> DISPLAY KEYS
<PF5> NOT USED      <PF6>  TEXT       <PF7> BACKWARD      <PF8> FORWARD

Description

This panel displays additional attributes not shown on the COLUMN DISPLAY panel. Display this panel by selecting the EXTENDED DEF PF key on the COLUMN DISPLAY panel (DQB20).

Action

When this panel is displayed, you can view the attributes of the column or use the cursor position to select a column.

Display Fields

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

TABLE:

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

Names of the columns for the table you selected.

TYPE

Data types of each column:

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/I

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).

NULL

You may assign null values to this field.

OCC

Number of occurrences. Contains a 1 if not a repeating column.

CLASS

C

Compound for group columns

S

Simple for single columns

F

Filler for place-holder columns

Numeric

Packed, Zoned and Halfword Binary types and lengths are reported as numeric and may not indicate an appropriate match for RELATED BY statements.

DATE/TIME

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.

<PF4> DISPLAY KEYS

Displays the KEY DISPLAY panel (DQB50).

<PF6> TEXT

Displays text description on TEXT DISPLAY (COLUMN) panel (DQB40).

<PF7> BACKWARD

Scrolls the list backward.

<PF8> FORWARD

Scrolls the list forward.