Usage Note 33451: An error occurs when you run a DB2 stored procedure that has a question mark for a parameter value in SAS/ACCESS® Interface to DB2
 |  |  |  |  |
The following error occurs when you attempt to run a DB2 stored procedure in SAS/ACCESS® Interface to DB2:
ERROR: CLI execute error: [IBM][CLI Driver] CLI0100E Wrong number of parameters. SQLSTATE=07001
The error occurs when you submit an SQL procedure, such as the following, that contains a question mark as a parameter value:
proc sql;
connect to db2 (db=DBD1 user=user-name password=password);
execute ( call OY.YMPGFM00 ('CHUCK','G','00',?)) by db2 ;
disconnect from db2 ;
quit;
The procedure works without error when it is executed with the DB2 Command Line Processor.
To circumvent this problem, do one of the following:
- Use literal values instead of question marks for your parameters.
- Create a new stored procedure that calls the stored procedure containing the question-mark parameter value. Then call the new stored procedure from SAS.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to DB2 | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 SP4 | |
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.1 TS1M3 SP4 | |||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.1 TS1M3 SP4 | |||
| Microsoft Windows XP 64-bit Edition | 9.1 TS1M3 SP4 | |||
| Microsoft® Windows® for x64 | 9.1 TS1M3 SP4 | |||
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 SP4 | |||
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 SP4 | |||
| Microsoft Windows 2000 Server | 9.1 TS1M3 SP4 | |||
| Microsoft Windows 2000 Professional | 9.1 TS1M3 SP4 | |||
| Microsoft Windows NT Workstation | 9.1 TS1M3 SP4 | |||
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 SP4 | |||
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 SP4 | |||
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 SP4 | |||
| Microsoft Windows XP Professional | 9.1 TS1M3 SP4 | |||
| Windows Vista | 9.1 TS1M3 SP4 | |||
| 64-bit Enabled AIX | 9.1 TS1M3 SP4 | |||
| 64-bit Enabled HP-UX | 9.1 TS1M3 SP4 | |||
| 64-bit Enabled Solaris | 9.1 TS1M3 SP4 | |||
| HP-UX IPF | 9.1 TS1M3 SP4 | |||
| Linux | 9.1 TS1M3 SP4 | |||
| Linux on Itanium | 9.1 TS1M3 SP4 | |||
| Solaris for x64 | 9.1 TS1M3 SP4 | |||
A fix for this issue for SAS/ACCESS Interface to DB2 9.21_M2 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/B94.html#33451| Type: | Usage Note |
| Priority: |
| Date Modified: | 2011-08-08 15:26:26 |
| Date Created: | 2008-09-29 11:39:42 |