Display a Personal Table Definition

Displaying Personal Table Definitions › Display a Personal Table Definition

Display a Personal Table Definition

You can see the definitions of all the columns making up any personal table. Use the DISPLAY TABLE panel as an aid to understanding table structure when creating a query or dialog that references the table.

Action

Follow these steps to display a table definition.

Step 1: Display DIRECTORY OF TABLES panel (DQT10).
Step 2: Position cursor on a table name.
Step 3: Press <PF5> DISPLAY.

CA Dataquery displays a DISPLAY TABLE (DQT20) panel for the table chosen.

Panel

The following shows a typical DISPLAY TABLE (DQT20).

 =>

 --------------------------------------------------------------------------DQT20
 DATAQUERY:  DISPLAY TABLE         TABLE NAME:  STAFF
 -------------------------------------------------------------------------------
 COLUMN NAME                      |   TYPE    | LENGTH
 -------------------------------------------------------------------------------
 ID                               | SMALLINT  |        7
 NAME                             | CHARACTER |        9
 DEPT                             | SMALLINT  |        7
 JOB                              | CHARACTER |        5
 YRS                              | 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

The DISPLAY TABLE panel shows the table name along with the name of each column, its type, and its length.

The following describes the information displayed.

COLUMN NAME

Contains a one-word name for each column named on the table.

TYPE

Shows the type of data the column listed to the left can contain. Data may be:

CHARACTER -- all displayable characters.
NUMERIC -- signed numeric data with zoned decimals.
DECIMAL -- packed decimal numeric data.
FLOAT -- floating-point.
SMALLINT -- small integer numbers.
INTEGER -- large integer numbers.

The most commonly used data types are character or numeric. See the CA Dataquery Reference Guide for more information on data types.

LENGTH

Shows the maximum number of characters per row for a 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.

Operation

Scroll backward and forward on the list of columns using <PF7> BACKWARD and <PF8> FORWARD.

Other Things You Can Do

The PF keys at the bottom of the DISPLAY TABLE (DQT20) panel allow access to other features.

Delete this personal table and its data.: Press <PF4> DROP with the cursor on a table name. See Deleting a Table for instructions.
Create a new personal table by copying an existing definition of a table that has less than 99 columns.: Press <PF5> COPY while viewing the DISPLAY TABLE panel. See Copying a Personal Table Definition for instructions.
Add a row to a personal table.: Press <PF6> INSERT ROWS with the cursor on a table name.
Maintain rows in a personal table.: Press <PF9> MAINTAIN ROWS with the cursor on a table name. See Updating Rows for instructions.