Skip to content

Embedded Usage

The embedded CREATE PROCEDURE statement is identical to its interactive version, with the following exceptions and additions:

  • Braces { } cannot be used in place of the BEGIN and END clauses.

  • All statements in the procedure must be separated by semicolons. The statement terminator after the final END clause follows the syntax of the host language.

  • The CREATE PROCEDURE statement cannot contain any references to host language variables.

  • The rules for the continuation of statements over multiple lines follow the embedded SQL host language rules. String literals, continued over multiple lines, also follow the host language rules.

  • Comments in a procedure body follow the comment rules of the host language.

  • The INCLUDE statement cannot be issued inside a database procedure. However, an include file can contain an entire CREATE PROCEDURE statement.

The SQL syntax of the CREATE PROCEDURE statement is validated at runtime, not by the preprocessor.