(DQBD0) Extended Key Display

 =>
 PLACE THE CURSOR ON THE DESIRED NAME AND PRESS THE APPROPRIATE PFKEY.
 --------------------------------------------------------------------------DQBD0
 DATAQUERY:  EXTENDED KEY DISPLAY              TABLE:
 -------------------------------------------------------------------------------
   KEY NAME                             |
       COLUMN NAMES                     | 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 descriptions of keys shown on the KEY DISPLAY panel (DQB50). Display this panel by selecting the EXTENDED DEF PF key on any panels where it is displayed as an option.

Action

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

Display Fields

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

TABLE:: Name of the table whose keys and columns are listed on the panel.

Columns

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

KEY NAME/ COLUMN NAMES

Names of the keys and columns for the table you selected.

TYPE

Data types for 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 key/column, Y (has a + or - sign) or N (is unsigned).

NULL

You may assign null values.

OCC

Number of occurrences. If 1, it is not a repeating key/column.

CLASS

C: Compound for group keys/columns
S: Simple for single keys/columns
F: Filler for place-holder keys/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:

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.

Note: For details about data types, see SQL Statements or see the CA Datacom/DB SQL User Guide.

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 COLUMN DISPLAY panel (DQB20).
<PF6> TEXT: Displays text description.
<PF7> BACKWARD: Scrolls the list backward.
<PF8> FORWARD: Scrolls the list forward.