Embed SQL statements in C and C++ applications that use SQL

SQL statements can be coded in a C or C++ program wherever executable statements can appear.

Each SQL statement must begin with EXEC SQL and end with a semicolon (;). The EXEC SQL keywords must be on one line. The remaining part of the SQL statement can be on more than one line.

Example: An UPDATE statement coded in a C or C++ program might be coded in the following way:

   EXEC SQL
     UPDATE DEPARTMENT
     SET MGRNO = :MGR_NUM
     WHERE DEPTNO = :INT_DEPT ;

• Comments in C and C++ applications that use SQL
  In addition to using SQL comments (--), you can include C comments (/*...*/) within embedded SQL statements whenever a blank is allowed, except between the keywords EXEC and SQL.
• Continuation for SQL statements in C and C++ applications that use SQL
  SQL statements can be contained in one or more lines.
• Include code in C and C++ applications that use SQL
  You can include SQL statements, C, or C++ statements by embedding the following SQL statement in the source code.
• Margins in C and C++ applications that use SQL
  You must code SQL statements within the margins that are specified by the MARGINS parameter on the CRTSQLCI or CRTSQLCPPI command.
• Names in C and C++ applications that use SQL
  You can use any valid C or C++ variable name for a host variable. It is subject to the following restrictions:
• NULLs and NULs in C and C++ applications that use SQL
  C, C++, and SQL use the word null, but for different meanings.
• Statement labels in C and C++ applications that use SQL
  Executable SQL statements can be preceded with a label.
• Preprocessor sequence for C and C++ applications that use SQL
  You must run the SQL preprocessor before the C or C++ preprocessor. You cannot use C or C++ preprocessor directives within SQL statements.
• Trigraphs in C and C++ applications that use SQL
  Some characters from the C and C++ character set are not available on all keyboards. You can enter these characters into a C or C++ source program by using a sequence of three characters that is called a trigraph.
• WHENEVER Statement in C and C++ applications that use SQL
  The target for the GOTO clause in an SQL WHENEVER statement must be within the scope of any SQL statements affected by the WHENEVER statement.