You can use #define values in a declare section to dimension arrays and initialize variables. When you use #define in a host variable declaration, place it before the host variable declaration that uses it. For example, the following two examples are valid:
#define PLEN 26
CS_CHAR name[PLEN];
and:
exec sql begin declare section;
#define PLEN 26
exec sql end declare section;
...
exec sql begin declare section;
CS_CHAR name[PLEN];
exec sql end declare section;
You can use #define to declare symbolic names. Make the declaration before using it in the application. For example, to define “10” symbolically, use this nomenclature:
exec sql begin declare section;
#define count_1 10
CS_CHAR var1[count_1];
exec sql end declare section;