Adding Data to Personal Tables › Entering Data

Entering Data

The INSERT ROWS (DQT50) panel presents a listing of all defined columns of a particular table, along with their data types and lengths. It also provides blank fields for entering data. Use the panel to enter new data.

Action

To display the INSERT ROWS (DQT50) panel, follow these steps:

Step 1

Display the DIRECTORY OF TABLES (DQT10) panel and place the cursor on a table name. Or, display the DISPLAY TABLE (DQT20) panel for the table needed.

Step 2

Press <PF6> INSERT ROWS.

CA Dataquery displays the INSERT ROWS (DQT50) panel.

Following is an example of the INSERT ROWS (DQT50) panel.

INSERT ROWS (DQT50) Panel

  =>
 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 |
                                  |           |         |
 YRS                              | 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

The INSERT ROWS panel represents one row of a table you select. Use it to add rows to a table. The first three panel columns are for display only. The last panel column, titled VALUE, contains entry fields for each column listed in the panel column titled Column Name.

Description

Following is a description of the panel.

COLUMN NAME

(Display only)

Contains the name of a column in the current table.

TYPE

(Display only)

Shows the type of data the column 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 will be character or numeric. See the CA Dataquery Reference Guide for more information on data types.

LENGTH

(Display only. No length for FLOAT, SMALLINT OR INTEGER types.)

Shows the maximum length of a value for the named column. If there are two numbers, the first number is the total length and the second number is the number of decimal places. The number given does not include the spaces needed for a sign, commas or the decimal point.

VALUE

(Data entry fields.)

Provides an entry field for each table column named on the panel. If a column's length exceeds one line of the VALUE column, the entry field wraps to occupy as many lines as needed.