3. Embedded SQL for COBOL : Embedded SQL Statement Syntax for COBOL : Terminator
 
Share this page                  
Terminator
The terminator for COBOL embedded SQL statements is the keyword end-exec. This terminator delimits an embedded SQL statement from the statement that follows it in the file. The following is an example of a select statement embedded in a COBOL program.
Example: Terinator END-EXEC usage
EXEC SQL SELECT ename
        INTO :NAMEVAR
        FROM employee
    WHERE eno = :NUMVAR
        END-EXEC
You have the option of following the end-exec terminator with the COBOL separator period.
Example: Separator period usage
EXEC SQL SELECT ename
    INTO :NAMEVAR
    FROM employee
    WHERE eno = :NUMVAR
    END-EXEC.
In general, be sure to include the separator period wherever COBOL requires it for a normal COBOL statement (for example, at the end of a COBOL IF statement).
Do not use spaces between end-exec and the separator period. Certain considerations can arise with the way in which the preprocessor interprets the period. For details, see Preprocessor Operation in this chapter.