| Table of Contents |
|---|
Version
4.3.9 or above
Explanation
Unable to create the procedure.
Cause
1024 is the maximum number of host variables that can be used. This error occurs if the number of host variables in the procedure exceeded this number.
Action
The WITH clause (for ALTIBASE HDB 6.3.1 or above) can be used to reduce the number of host variables. It can use more than 1024 by using variable substitution as shown below.
| Code Block | ||
|---|---|---|
| ||
WITH dataset1 AS (SELECT V_YYYYMM AS V_EXEC_YYYYMM FROM dual ) |
For versions below 6.3.1, either separate the processing modules for each task or change the logic to handle it in a different way, apart from a host variable as the WITH clause is not supported.
Reference
N/A