As mentioned in the SQL Reference Guide, the create procedure statement has language-specific syntax rules for line continuation, string literal continuation, comments, and the final terminator. These syntax rules follow the rules discussed in this section—for example, the ampersand is used to continue lines. Regardless of the number of statements inside the procedure body, the preprocessor treats the create procedure statement as a single statement and, as an Embedded SQL/BASIC statement, it has no final terminator. However, you must terminate all statements in the body of the procedure with a semicolon.

The following example shows a create procedure statement that follows the Embedded SQL/BASIC syntax rules: