Finding Personal Table Rows

Maintaining Personal Databases › Finding Personal Table Rows

Finding Personal Table Rows

When you find a row in any personal table, you can change (update) any value or delete the whole row. Finding rows of data in a personal table requires that you display the MAINTAIN ROWS (DQT40) 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 <PF9> MAINTAIN ROWS.

CA Dataquery displays the MAINTAIN ROWS (DQT40) panel.

Panel

The MAINTAIN ROWS (DQT40) panel presents a listing of all defined columns of a particular table, along with their data types and lengths. It also provides entry fields for comparison operators and comparison data. Use the panel to find specific rows of data or all rows of data.

Following is an example of the MAINTAIN ROWS (DQT40) panel.

MAINTAIN ROWS (DQT40)

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

The MAINTAIN ROWS panel represents one row of a table you select. Use it to find existing rows. The first three panel columns are for display only. The last two panel columns contain entry fields.

Following is a description of the display columns on this panel.

COLUMN NAME

(Display only)

Contains the name of a data entry column for 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 entry for FLOAT, SMALLINT OR INTEGER types.)

Shows the maximum number of characters per row for a 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.

Action

To find all of the data in a personal table, follow these steps using the MAINTAIN ROWS (DQT40) panel.

Step 1: Display the MAINTAIN ROWS (DQT40) panel for the table needed, as discussed in Finding Personal Table Rows.
Step 2: Press <PF3> SELECT to display DATA DISPLAY (DQT60), representing the first row of the table.

To find specific data, use the MAINTAIN ROWS (DQT40) panel to enter operators and values on the panel to specify the data you want found. Follow these steps:

Step 1

Display the MAINTAIN ROWS (DQT40) panel for the table needed, as discussed in Entering Data.

Step 2

Put the cursor in the COMP field for a column you want to search and enter a valid relational operator. The operator tells CA Dataquery how to compare the values it reads on each row to a value to be entered in the corresponding VALUE field. Rows containing values that meet the search criteria will be selected for display.

Choose from these operators:

Equal: = or EQ
Less than: < or LT
Greater than: > or GT
Less than or greater than: <> or LOG
Less than or equal: <= or LTE
Greater than or equal: >= or GTE
Not equal: ¬= or NE
Not less than: ¬< or NLT
Not greater than: ¬> or NGT

Step 3

Move the cursor to the following VALUE field and enter a value for comparison to the values in the table column. If a VALUE entry field is longer than 22 characters, the entry field wraps to the next line. You can enter search criteria for any or all columns as long as a comparison operator is also entered in the preceding COMP field.

Step 4

Press <PF3> SELECT to display DATA DISPLAY (DQT60), representing the first row found that matches the search criteria.

Panel

Following is an example of the DATA DISPLAY (DQT60) panel containing typical data.

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

The DATA DISPLAY (DQT60) panel displays the total number of rows found and also tells which sequential row is currently displayed.

Operation

The following shows how to use PF keys to view the rows found by CA Dataquery.

Scroll forward to see additional lines for this row.: Press <PF8> FORWARD.
Scroll back to see previous lines for this row.: Press <PF7> BACKWARD.
Display the next sequential row of the rows found.: Press <PF12> NEXT ROW.
Display the previous sequential row of the rows found.: Press <PF11> PREV ROW.

Additional PF keys allow you to update and delete displayed records.