ERR-201436

The number of host variables exceed the maximum limit (1024)

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.

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

Copyright ⓒ 2000~2016 Altibase Corporation. All Rights Reserved.

These documents are for informational purposes only. These information contained herein is not warranted to be error-free and is subject to change without notice. Decisions pertaining to Altibase’s product characteristics, features and development roadmap are at the sole discretion of Altibase. Altibase may own related patents, trademarks, copyright or other intellectual property rights of products and/or features discussed in this document.