In C Language programs, you must precede embedded SQL statements with the EXEC SQL delimiter so that the precompiler can distinguish statements from the host language statements.
Note: Constructs within a BEGIN-END DECLARE SECTION do not require the EXEC SQL delimiter.
Syntax
EXEC SQL sql_statement ;
Parameter
sql_statement
An SQL statement to be processed by the ESQL precompiler. You must terminate each SQL statement with a semicolon to mark the end of the statement.
Notes
In general, the ESQL precompiler does not parse host language statements and therefore does not detect any syntax or semantic errors in host language statements. The exceptions to this rule are:
Recognition of host language blocks. The precompiler recognizes host language blocks in order to determine the scope of variables and types.
Constants defined with the #define preprocessor command. To evaluate these constants, the ESQL precompiler invokes the C language preprocessor before beginning embedded SQL processing.
Example
EXEC SQL WHENEVER SQLERROR GOTO selerr ;
EXEC SQL PREPARE stmtid from :sel_stmt_v ;
EXEC SQL DECLARE dyncur CURSOR FOR stmtid ;
EXEC SQL OPEN dyncur ;
EXEC SQL WHENEVER NOT FOUND GOTO seldone ;
Recognition of host language blocks. The precompiler recognizes host language blocks in order to determine the scope of variables and types.
