You execute a query with an ERASE, INSERT, or UPDATE statement by pressing the APPLY PF key when the Table Maintenance panel (DQEI0) appears.
A sample Table Maintenance panel for INSERT follows:
Table Maintenance (DQEI0)
=> 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
Purpose
The Table Maintenance panel displays the rows that are to be maintained on a CA Datacom/DB table. This panel displays only. To perform the actual maintenance on the table, press <PF3> APPLY. This panel gives you a chance to view the rows that you are intending to maintain, before the maintenance actually takes place. In other words, you have a second chance before you UPDATE or ERASE the rows.
Panel Description
The following list describes each field of the Table Maintenance panel:
The name of the table to be updated.
The maintenance function to be performed, ERASE, INSERT, or UPDATE.
The number of records to be updated, inserted or erased.
The page number of the display.
If this appears, the number of records to be updated, or erased has exceeded the number of found table blocks that the user can use. (Make the selection criteria more selective or increase the FNDBLKS= parameter.)
Action
When you are satisfied that the rows displayed on this panel are the ones to be maintained press <PF3> APPLY to ERASE, INSERT, or UPDATE the rows according to your query.
|
Copyright © 2014 CA.
All rights reserved.
|
|