(DQEI0) Table Maintenance

 =>
 Press PF3 to apply changes to table
 --------------------------------------------------------------------------DQEI0
 DATAQUERY:  TABLE MAINTENANCE                                 PAGE:   ______
 -------------------------------------------------------------------------------
 TABLE:      ________________________________
 FUNCTION:   ______                NUMBER SELECTED:    _____     LIMIT EXCEEDED
 -------------------------------------------------------------------------------
 
 
 
 
 
 
 
 
 
 
 
 
 
 -- ------------------------------           ------------------------------- --
 <PF1> HELP     <PF2> RETURN   <PF3> APPLY     <PF4> NOT USED   <PF5>  NOT USED
 <PF6> NOT USED <PF7> BACKWARD <PF8> FORWARD   <PF9> LEFT       <PF10> RIGHT

Description

The Table Maintenance panel appears whenever a query containing an UPDATE or ERASE statement is executed. It displays the rows to be added, updated, or deleted, allowing you to verify the changes to the table before they occur. UPDATE and ERASE statements require special authorization. Their use is documented in the CA Dataquery Administrator Guide.

Action

View the displayed rows to verify that the changes should be applied to the table. You may use the <PF7> and <PF8> keys to scroll the list backward and forward. If the changes should be applied to the table, press the <PF3> key otherwise the changes will not be applied. Press the <PF2> key to return to the previous panel, or press the CLEAR key to return to the Main Menu.

Display Fields

The fields on this panel are for display only. No data can be entered. Refer to the following for explanations of the display fields intended to contain variable data.

PAGE:: Page number of the displayed rows.
TABLE NAME:: Names the table to which changes will be applied.
FUNCTION:: UPDATE or ERASE.
NUMBER SELECTED:: Number of rows selected for maintenance in the table named at the top of the panel.

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> APPLY: Applies the changes to the table.
<PF7> BACKWARD: Scrolls display backward one page.
<PF8> FORWARD: Scrolls display forward one page.
<PF9> LEFT: Scrolls display left.
<PF10> RIGHT: Scrolls display right.