(DQT50) Insert Rows

 =>
 Enter VALUE(S) IN THE VALUE COLUMN AND PRESS PF3 TO INSERT THE ROW
 --------------------------------------------------------------------------DQT50
 DATAQUERY:  INSERT ROWS           TABLE NAME:  STAFF
 -------------------------------------------------------------------------------
  COLUMN NAME                     |   TYPE    | LENGTH  | VALUE
 -------------------------------------------------------------------------------
 ID                               | SMALLINT  |       5 |
 NAME                             | CHARACTER |       9 |
 DEPT                             | SMALLINT  |       5 |
 JOB                              | CHARACTER |       5 |
 JOB_DESCRIPTION                  | CHARACTER |      50 |
 YEARS                            | SMALLINT  |       5 |
 SALARY                           | DECIMAL   |   (7,2) |
 COMM                             | DECIMAL   |   (7,2) |
                                  |           |         |
                                  |           |         |
                                  |           |         |
                                  |           |         |
 - LAST PAGE -------------------------------------------------------------------
 <PF1> HELP        <PF2>  RETURN       <PF3>  INSERT       <PF4>  NOT USED
 <PF5> NOT USED    <PF6>  NOT USED     <PF7>  BACKWARD     <PF8>  FORWARD

Description

This panel appears as a result of pressing <PF6> INSERT ROWS during display of the Directory of Tables (DQT10) or during display of the Display Table (DQT20) panels. The above panel shows the columns defined for the personal table, the valid data types for each column, and the maximum length of each column.

Action

Enter valid values in the fields provided to create a new row and then press <PF3> INSERT to insert the row in the table.

Display Fields

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

TABLE NAME:: Shows the name of the personal table to which you will add this row.

Columns

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

COLUMN NAME

Each display field in this column names a column defined in the table.

TYPE

Each display field in this column describes the data type defined for the column name to the left. 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

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.

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
VALUE	Y	Defined at left	None

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> INSERT: Inserts this row in the table.
<PF7> BACKWARD: Scrolls display backward one page.
<PF8> FORWARD: Scrolls display forward one page.