Similar to the directive #define that is known from C, embedded SQL has a similar concept:
EXEC SQL DEFINE name END-EXEC. EXEC SQL DEFINE name value END-EXEC.
So you can define a name:
EXEC SQL DEFINE HAVE_FEATURE END-EXEC.
And you can also define constants:
EXEC SQL DEFINE MYNUMBER 12 END-EXEC. EXEC SQL DEFINE MYSTRING 'abc' END-EXEC.
Use undef to remove a previous definition:
EXEC SQL UNDEF MYNUMBER END-EXEC.
Note that a constant in the SQL statement is only replaced by EXEC SQL DEFINE. The replacement may change the number of characters in a line, but ecobpg does not validate it after the replacement. Pay attention to the limitation of the number of characters in a line.
