Previous Topic: (DQED0) Column Value Display (Wide Screens)Next Topic: (DQEI0) Table Maintenance


(DQEG0) Table Maintenance

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

Description

The Table Maintenance panel appears whenever a query containing an INSERT 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. INSERT statements require special authorization. Their use is documented in the CA Dataquery Administrator Guide.

Action

View the displayed row 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 row.

TABLE:

Names the table to which changes will be applied.

FUNCTION:

INSERT.

NUMBER SELECTED:

Always one row.

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.

<PF5> PREV ROW

No effect.

<PF6> NEXT ROW

No effect.

<PF7> BACKWARD

Scrolls display backward one page.

<PF8> FORWARD

Scrolls display forward one page.

<PF9> LEFT

Scrolls display left.

<PF10> RIGHT

Scrolls display right.