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 (see page
Preprocessor Operation) in this chapter.