Line Continuation
You can continue embedded SQL statements over multiple lines. The line continuation rules are the same as those for Fortran statements.
A line continuation indicator is:
• UNIX:
An ampersand (&) in the first column or any character
in column 6, except a blank or zero
• VMS:
Any digit, except zero, following the first tab
• Windows:
Any character except zero or blank in column 6
The preprocessor considers the characters after the continuation indicator to be the first characters of the line. For example, the following select statement continues over four lines:
exec sql select ename
1 into :namvar
2 from employee
3 where eno = :numvar
You can put blank lines between Embedded SQL statement lines. Blank lines do not require a continuation indicator. If a line continuation indicator is missing from an Embedded SQL statement that spans more than one line, the preprocessor generates the following error message: "Syntax error on terminator or missing Fortran continuation indicator".
You must use the continuation indicator to continue Embedded SQL/Fortran declarations over multiple lines. Comments (except comments that use the SQL comment delimiters--see
Comments)) cannot continue over multiple lines.
VMS:
You cannot continue variable initialization clauses over multiple lines.
