Problem Note 32067: An error might occur when you call a DB2 stored procedure that has an argument longer than 256 characters
 |  |  |  |  |
If you try to call a DB2 stored procedure where an argument is longer than 256 characters, you might receive an error message similar to one of the following messages:
SNT408I SQLCODE = -312, ERROR: PAR03 IS AN UNDEFINED OR UNUSABLE
HOST VARIABLE
DB2/StoredProc: single quoted constant too big
Currently, the maximum length for a paremeter within single or double quotation marks is limited to 256 characters.
Select the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to DB2 | z/OS | 9.1 TS1M3 SP4 | 9.2 TS1M0 |
A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:
http://www.sas.com/techsup/download/hotfix/e9_sbcs_prod_list.html#032067A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at:
http://www.sas.com/techsup/download/hotfix/e9_dbcs_prod_list.html#032067| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2009-09-14 12:45:04 |
| Date Created: | 2008-05-12 12:45:48 |