Calls an editor that lets you modify the SQL statements you
issued within a terminal session.
SQL supports a variety editors, some of which are:
o EDT
o DEC Text Processing Utility (DECTPU) editors on OpenVMS, such
as EVE
o Language-Sensitive Editor (LSE) on OpenVMS, which is based
on DECTPU and provides templates that guide you in entering
syntactically correct statements
To invoke an editor other than the default, you must define the
SQL$EDIT logical name.
You can use the editor you choose with your usual initialization
file to modify your previous SQL statements, construct your next
statement or group of statements, or include a file with other
statements.
1 – Environment
You can issue the EDIT statement only in interactive SQL.
2 – Format
EDIT --+--------------+-->
+-> <number> --+
+-> * ---------+
3 – Arguments
3.1 – *_(wildcard)
Specifies a wildcard character. If you use the * (asterisk)
wildcard character, SQL includes in the editing buffer the number
of statements specified in the last SET EDIT KEEP statement.
If you do not use the SET EDIT KEEP statement, EDIT * puts the
last 20 statements in your editing buffer. If you omit the *
(asterisk) wildcard character, SQL includes the last statement
issued in the editing buffer.
3.2 – number
Specifies the number of previous statements you want to edit,
up to the number specified in the last SET EDIT KEEP statement.
If you specify zero as the number, then SQL does not include
any statements in the editing buffer. If you omit the number
argument, SQL includes the last statement issued in the editing
buffer.
4 – Examples
Example 1: Correcting a misspelled statement
1. Make a mistake:
SQL> SELECT JOB_TITLE FROM JOSB;
%SQL-F-RELNOTDEF, Table JOSB is not defined in schema
SQL>
2. Invoke the editor:
SQL> EDIT
3. When in the editor, change JOSB to JOBS. See the manual for
the editor you are using for detailed editing instructions.
4. Exit from the editor. SQL automatically executes the contents
of the editing buffer.
* EXIT
SELECT JOB_TITLE FROM JOBS;
Associate Programmer
Clerk
Assistant Clerk
Department Manager
Dept. Supervisor
.
.
.