User`s guide

Running SQL*Plus
SQL*Plus 3-3
When you press the INTERRUPT key [K2], the Oracle Database stops retrieving rows
and returns you to the SQL*Plus command level.
3.1.4 Issuing BS2000 Commands from SQL*Plus
The SQL*Plus HOST command and the $ command enable you to enter a BS2000
command while you are logged on to SQL*Plus.
The following BS2000 commands, if used with the HOST or $ command, do not return
you to SQL*Plus when they have finished running:
■ START-PROGRAM
■ LOAD-PROGRAM
■ CALL-PROCEDURE
■ HELP-SDF
■ LOGOFF
Some examples of how you can use the HOST command:
■ If you enter the HOST command without any BS2000 command, then it takes you to
the command level:
SQL> HOST
To return to SQL*Plus, you must use the RESUME command.
■ If you enter the HOST command with a BS2000 command, then the command is run
and you return to SQL*Plus:
SQL> HOST STA L
3.1.5 Starting the BS2000 Editor
You can use the SQL*Plus EDIT command to start the BS2000 editor:
SQL> EDIT
This command:
■ writes the SQL buffer (which contains the current SQL statement) to a file called
SQLEDT.BUF
■ starts the editor EDT, which reads the file SQLEDT.BUF into the work area
You can then edit and write to this file (using the @write command). Using the @halt
command, you can leave the editor and return to SQL*Plus. SQL*Plus then reads the
current contents of
SQLEDT.BUF back into its command buffer, from which the SQL
statement can be run.
Note: If you issue an INTERRUPT when input is requested, then you
must answer this request before the processing can be interrupted.
However, this answer will be ignored.
Note: If you used the SQL*Plus DEFINE _EDITOR command to define
a name for the editor, then BS2000 will ignore it. It always starts EDT.