(DQT60) Data Display

 =>
 DQ471I - RECORDS FOUND: 000038
 --------------------------------------------------------------------------DQT60
 DATAQUERY:  DATA DISPLAY          TABLE NAME:  STAFF
                                   ROWS SELECTED: 00038 ROW DISPLAYED: 00001
 -------------------------------------------------------------------------------
  COLUMN NAME                     |   TYPE    | LENGTH  | VALUE
 -------------------------------------------------------------------------------
 ID                               | SMALLINT  |       5 | 0
 NAME                             | CHARACTER |       9 |
 DEPT                             | SMALLINT  |       5 | 0
 JOB                              | CHARACTER |       5 |
 YEARS                            | SMALLINT  |       5 | 0
 SALARY                           | DECIMAL   |   (7,2) | 0.00
 COMM                             | DECIMAL   |   (7,2) | 0.00
                                  |           |         |
                                  |           |         |
                                  |           |         |
                                  |           |         |
                                  |           |         |
 - LAST PAGE -------------------------------------------------------------------
 <PF1> HELP        <PF2>  RETURN       <PF3>  NOT USED     <PF4>  UPDATE ROW
 <PF5> DELETE ROW  <PF6>  NOT USED     <PF7>  BACKWARD     <PF8>  FORWARD
 <PF9> NOT USED    <PF10> NOT USED     <PF11> PREV ROW     <PF12> NEXT ROW

Description

This panel shows the total number of rows found after pressing <PF3> SELECT during display of the Maintain Rows (DQT40) panel. It tells which sequential row is currently displayed and shows the definition and value of each column in the current row. If More appears, the display continues beyond the current panel.

Action

Page through the panels representing each row to display current data. To change a row, enter valid data in the Value fields, typing over displayed data where necessary. Press <PF4> UPDATE ROW to change the data. Other PF keys allow you to delete the entire row, page forward and backward through the current row, or see the previous or next row.

Display Fields

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

TABLE NAME:: Names the personal table whose rows are currently displayed.
ROWS SELECTED:: Shows the number of rows included in this display.
ROW DISPLAYED:: Shows the sequential number of 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	N	Shown at left	Displayed

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.
<PF4> UPDATE ROW: After entering new data in Value fields, press this key to save the entries.
<PF5> DELETE ROW: Removes this row and its data from the table.
<PF7> BACKWARD: Scrolls display backward one page.
<PF8> FORWARD: Scrolls display forward one page.
<PF11> PREV ROW: Displays first page of a previous row, if any.
<PF12> NEXT ROW: Displays first page of next row, if any.