PURPOSE: This command allows interactive and repetitive execution of OSQL and interactive command language (ICL) commands from a command buffer.
OSQL EDIT [NEW]
|
NEW |
clears current command buffer |
*OSQL EDIT
*OSQL EDIT NEW
NOTES: OSQL EDIT defaults to the callable editor that is specified in the @EDITOR System Field (e.g. EDIT/EDT or EDIT/TPU). The command text is stored in the command buffer. The commands are executed when the editor is exited. This allows for batch processing of commands. The commands will only stay in the command buffer for the period of the session. The commands may be re-edited with OSQL EDIT and re-executed. The command buffer may also be cleared with the NEW parameter to insert new commands into the command buffer. Commands may be saved permanently by defining a Command Module, inserting the command text, and saving with the editor commands.
Please note that OSQL EDIT uses the file SYS$SCRATCH:###ACCSQL_EDIT.TMP, where ### is the value stored in the @UNIQUE_ID System Field. You may wish to delete these files after the nightly back-up procedure runs.