DB2 FOR LUW / DB2FORLUW / 970 - DB2

Delete statement without 'from' clause against a database 
created with Oracle Compatibility mode fails with SQl0313N when 
host variables are used in a CLI application. 
 
Example: 
 
Delete t2 where col1 = :1 and col2 = :2 
 
[IBM][CLI Driver][DB2/6000] SQL0313N  The number of var 
iables in the EXECUTE statement, the number of variables in the 
OPEN statement, 
or the number of arguments in an OPEN statement for a 
parameterized cursor is no 
t equal to the number of values required.  SQLSTATE=07004

**************************************************************** 
* USERS AFFECTED:                                              * 
* All V9.7 users with ORACLECOMPATIBILITY MODE                 * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to V9.7 FP8                                          * 
****************************************************************

Use parameter markers instead of host variables. 
Delete t2 where col1 = ? and col2 = ?

DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

First fixed in V9.7 FP8

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC86333 
follow-up : 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

08.08.2012
02.04.2013
02.04.2013

9.7.FP8