5. Embedded SQL for Ada : Embedded SQL Statement Syntax for Ada : Labels
 
Share this page                  
Labels
Like Ada statements, Embedded SQL statements can have a label prefix. The label must begin with an alphabetic character, must be the first word on the line (optionally preceded by white space), and must be delimited with double angle brackets. For example:
<<close_cursor>> exec sql close cursor1;
The label can appear anywhere an Ada label can appear. Even though the preprocessor accepts the label in front of any exec sql or exec frs prefix, it may not be appropriate to code it on some lines. For example, the following, although acceptable to the preprocessor, later generates a compiler error because labels are not allowed before declarations:
<<include_sqlca>> exec sql include sqlca;
As a general rule, use labels only with executable statements.