SQL Language Guide : 7. SQL Statements : CREATE PROCEDURE : Embedded Usage
 
Share this page                  
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.