Progress
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.
NOTE: 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 program4DynSel.pc
, which illustrates dynamic processing of a SELECT statement. The complete source for sample program,2StatSel.pc
, is listed in Appendix A of the Progress Embedded SQL-92 Guide and Reference .
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 |