This option specifies whether to expand the definition method of SQL host variables (SQLGRP) or not (NOSQLGRP). When NOSQLGRP is specified, a REDEFINE clause cannot be specified to the host variable.
Item | Description | |
|---|---|---|
SQL host variable definition expansion | Specifies whether to expand the definition method of SQL host variables. The default is SQLGRP. | |
SQLGRP | Expands the definition method. | |
NOSQLGRP | Does not expand the definition method. | |
Note
When SQLGRP is specified, you cannot determine whether the data item has a correct format as a host variable just with the data description entry. This means that the syntax check for the host variable definitions during compilation differs as follows:
The host variables not referenced in an embedded SQL statement are not subject to syntax check. Here, only the host variable names for the group items having global attribute are checked.
More strict syntax check is made to variable-length character-type host variables. Group items containing items of level number 49 are handled as variable-length character-type host variables.
Specify NOSQLGRP for the conventional syntax check without using the host variables which are defined as group items.
