Panels › (DQT40) Maintain Rows

(DQT40) Maintain Rows

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

Description

This panel defines one row of a personal table. The fields in the first three columns are display only. The fields in the last two columns allow you to enter comparison operators and search criteria to specify a subset of rows that you want to see.

Action

Press <PF3> SELECT without making entries to display all rows of the table. Or, to see a subset of data, enter operators and search criteria and then press <PF3> SELECT. To exit without finding rows, press <PF2> RETURN.

Display Fields

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

TABLE NAME:

Names the table whose definitions are currently displayed.

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.

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> SELECT

Displays qualified rows.

<PF7> BACKWARD

Scrolls display backward one page.

<PF8> FORWARD

Scrolls display forward one page.