SQL$HELP72.HLB  —  EDIT
    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

  (B)0EDIT qqwqqqqqqqqqqqqqqwqq> 
         tq> <number> qqu    
         mq> * qqqqqqqqqj    

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
              .
              .
              .
Close Help