(DQT30) Create Table

 =>
 Enter information for table columns and press appropriate PF key
 --------------------------------------------------------------------------DQT30
 DATAQUERY:  CREATE TABLE          TABLE NAME:  ________________________________
 -------------------------------------------------------------------------------
 COLUMN NAME                      |   TYPE    | LENGTH
 -------------------------------------------------------------------------------
 CUST-ID                          | CHARACTER |  5
 IND-CD                           | CHARACTER |  1
 CUST-NO                          | CHARACTER |  4
 NAME                             | CHARACTER |  30
 ADDR-1                           | CHARACTER |  30
 ADDR-2                           | CHARACTER |  30
 CITY                             | CHARACTER |  15
 STATE                            | CHARACTER |  2
 ZIP                              | CHARACTER |  9
 CRED-IND                         | CHARACTER |  1
 PHONE                            | CHARACTER |  10
 AREA-CD                          | CHARACTER |  3
 PH-EXCH                          | CHARACTER |  3
 PH-NO                            | CHARACTER |  4
 -------------------------------------------------------------------------------
 <PF1> HELP          <PF2> RETURN        <PF3> ADD TABLE     <PF4> NOT USED
 <PF5> INSERT COLUMN <PF6> DELETE COLUMN <PF7> BACKWARD <PF8> FORWARD

Description

This panel appears when you copy an existing table definition or when you press <PF3> CREATE during display of the Display Tables (DQT10) panel. Use it to record (or change, if copying) the definitions for a new personal table. Be aware that the maximum number of columns in a personal table is 99.

Action

Type in column names and define their data types and lengths. Then press <PF5> ADD TABLE to finish creating the table.

Entry Fields

Refer to the following chart for valid entries in the fields on this panel. Use the Tab and arrow keys to move the cursor. To change an entry, write or space over it. When entries are complete, press Enter or a valid PF key.

Field	Required?	Valid Entries	Default
TABLE NAME:	Y	A one-word name (See following)	None
COLUMN NAME	Y	A one-word name	None

When no key is specified, the first column becomes the key by default. The Datadictionary limit for a key is 180 characters. This limit becomes important if the table is to be accessed with a DQL Mode query.

Table and column names must begin with an alphabetic character and use up to 32 characters, including letters, numbers, and underscores (_).

Columns

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

COLUMN NAME

Each display field in this column of the panel contains the name of a column defined in the table.

TYPE

Each display field in this column describes the data type defined for the column to the left. See Data Types for more information about data types.

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

LENGTH

Defines the number of positions in the column named to the left. Not used for float, smallint, or integer data types. If there are two numbers separated by a comma, the first number shows total length and the second number shows decimal positions.

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.
<PF3> ADD TABLE: Creates the newly defined table.
<PF5> INSERT COLUMN: Inserts a blank line for defining a new column.
<PF6> DELETE COLUMN: Erases a column definition.
<PF7> BACKWARD: Scrolls list backward one page.
<PF8> FORWARD: Scrolls list forward one page.