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 (see page
Comments)) cannot continue over multiple lines.
VMS
You cannot continue variable initialization clauses over multiple lines.
