Progress
Embedded SQL-92
Guide and Reference
EXEC SQL Delimiter
In C Language programs, you must precede embedded SQL-92 statements with the EXEC SQL delimiter so that the precompiler can distinguish statements from the host language statements. Constructs within a BEGIN-END DECLARE SECTION do not require the EXEC SQL delimiter.
SYNTAX
sql_statement
An SQL-92 statement to be processed by the ESQLC precompiler. You must terminate each SQL-92 statement with a semicolon to mark the end of the statement.
EXAMPLEThis example is a code fragment from the
DynSel
function in sample program 4DynSel.pc. This example illustrates the dynamic processing of a SELECT statement. The complete source for the sample program is listed in "ESQL-92 Sample Programs."
NOTE
- In general, the ESQLC 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 ESQLC precompiler invokes the C Language preprocessor before beginning embedded SQL-92 processing.
AUTHORIZATION
None
SQL COMPLIANCE
SQL-92
ENVIRONMENT
Embedded SQL-92 only
RELATED STATEMENTS
None
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |