Was this helpful?
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.
Last modified date: 08/28/2024