7.5 ECPGPlus Statements

Table of Contents Previous Next


7 Reference : 7.5 ECPGPlus Statements

You can embed any Advanced Server SQL statement in a C program. Each statement should begin with the keywords EXEC SQL, and must be terminated with a semi-colon (;). Within the C program, a SQL statement takes the form:
EXEC SQL sql_command_body;
Where sql_command_body represents a standard SQL statement. You can use a host variable anywhere that the SQL statement expects a value expression. For more information about substituting host variables for value expressions, please see Section 3.1.2, Declaring Host Variables.
ECPGPlus extends the PostgreSQL server-side syntax for some statements; for those statements, syntax differences are outlined in the following reference sections. For a complete reference to the supported syntax of other SQL commands, please refer to the PostgreSQL Core Documentation available at:

7 Reference : 7.5 ECPGPlus Statements

Table of Contents Previous Next