(DQT20) Display Table

 =>
 
 --------------------------------------------------------------------------DQT20
 DATAQUERY:  DISPLAY TABLE         TABLE NAME:  STAFF
 -------------------------------------------------------------------------------
 COLUMN NAME                      |   TYPE    | LENGTH
 -------------------------------------------------------------------------------
 ID                               | SMALLINT  |      7
 NAME                             | CHARACTER |      9
 DEPT                             | SMALLINT  |      7
 JOB                              | CHARACTER |      5
 YEARS                            | SMALLINT  |      3
 SALARY                           | DECIMAL   |  (7,2)
 COMM                             | DECIMAL   |  (7,2)
                                  |           |
                                  |           |
                                  |           |
                                  |           |
                                  |           |
                                  |           |
 - LAST PAGE -------------------------------------------------------------------
 <PF1> HELP          <PF2> RETURN       <PF3> NOT USED     <PF4> DROP
 <PF5> COPY          <PF6> INSERT ROWS  <PF7> BACKWARD     <PF8> FORWARD
 <PF9> MAINTAIN ROWS

Description

This panel shows the definitions of all the columns making up a personal table.

Action

Display this panel when you want a reference to understanding table structure during query or dialog creation. Or, use the PF keys to copy the definitions to a new table or to insert rows of data in the existing table. Be aware that the maximum number of columns in a personal database table is 99.

Display Fields

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

TABLE NAME:: Name of the personal table currently displayed.

Columns

Refer to the following for a discussion of each column on this panel.

COLUMN NAME

Lists the names of all columns that make up the table.

TYPE

See Data Types for explanations of these data types:

CHARACTER: All displayable characters
NUMERIC: Signed or unsigned numeric data with zoned decimals
DECIMAL: Packed decimal numeric data
FLOAT: Floating-point
SMALLINT: Small integer numbers
INTEGER: Large integer numbers

LENGTH

Shows the number of positions in the column. If two numbers are separated by a comma, read the first number as the total length and the second number as the number of decimal places. This is different from the way precision is shown in DQL Mode.

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> DROP: Deletes the currently displayed table.
<PF5> COPY: Copies the definitions to create a new table.
<PF6> INSERT ROWS: Adds data to the table.
<PF7> BACKWARD: Scrolls list backward one page.
<PF8> FORWARD: Scrolls list forward one page.
<PF9> MAINTAIN ROWS: Finds or changes data in the table.