General DDDL Syntax Options › Copying and Editing Entity Occurrences › SHOW Instruction of the EDIT Clause

SHOW Instruction of the EDIT Clause

SHOW requests or suppresses the listing of the results of subsequent INSERT, ERASE, or REPLACE instructions at the terminal or on the Integrated Data Dictionary Activity List. SHOW overrides SET OPTIONS statement BEFORE and AFTER clause specifications and remains in effect for all INSERT, ERASE, and REPLACE instructions until the DDDL compiler encounters another SHOW instruction or until the EDIT clause is terminated.

Syntax: SHOW Instruction of EDIT

►►─── SHOw ─┬─ ON ─────┬──────────────────────────────────────────────────────►◄
            ├─ OFF ────┤
            ├─ BEFore ─┤
            └─ AFTer ──┘

Parameters

SHOw

Specifies a SHOW operation.

ON

Selects both the AFTER IS ON and BEFORE IS ON defaults for the INSERT, ERASE, and REPLACE instructions in the current EDIT clause.

OFF

Selects both the AFTER IS OFF and BEFORE IS OFF defaults for the INSERT, ERASE, and REPLACE instructions in the current EDIT clause.

BEFore

Selects only the BEFORE IS ON default for the ERASE and REPLACE instructions in the current EDIT clause.

AFTer

Selects only the AFTER IS ON default for the INSERT and REPLACE instructions in the current EDIT clause.