Labels
Like Fortran statements, Embedded SQL statements can have a label prefix. An Embedded SQL label is a Fortran statement number specified between columns 1 and 5. For example:
100 exec sql close cursor1
The label can appear anywhere a Fortran label can appear. However, labels cause the preprocessor to generate Fortran continue statements. Therefore, you should precede only executable SQL statements with labels. Although the preprocessor accepts the label in front of any exec sql or exec frs prefix, it may not be appropriate to code the label on some lines. For example, the following label, although acceptable to the preprocessor, later causes a compiler error:
101 exec sql include sqlca
The preprocessor reserves statement numbers 7000 through 12000.