DB2 FOR LUW / DB2FORLUW / 970 - DB2

SQL401N is returned when all of the following conditions are 
 
satisfied: 
 
(1) Registry variable DB2_DEFERRED_PREPARE_SEMANTICS=YES or 
 
DB2_COMPATIBILITY_VECTOR=ORA has been set 
 
(2) target database is a non-unicode database 
 
(3) SQLExecute in CLI is preparing a statement with a comparison 
 
operator 
 
(4) One operand of the comparison operator mentioned in (3) is a 
 
parameter marker and C type/data used is double byte. 
 
 
 
(5) The other operand of the comparison operator in (3) resolves 
 
to type CHAR or VARCHAR

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* SQL401N is returned when all of the following conditions     * 
* aresatisfied:(1) Registry variable                           * 
* DB2_DEFERRED_PREPARE_SEMANTICS=YES                           * 
* orDB2_COMPATIBILITY_VECTOR=ORA has been set(2) target        * 
* database is a non-unicode database(3) SQLExecute in CLI is   * 
* preparing a statement with acomparisonoperator(4) One        * 
* operand of the comparison operator mentioned in (3)is        * 
* aparameter marker and C type/data used is double byte.(5)    * 
* The other operand of the comparison operator in (3)resolves  * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 UDB version 9.7 fix pack 3.                   * 
****************************************************************

(1) Issue "db2set DB2_DEFERRED_PREPARE_SEMANTICS=NO", or 
 
(2) Use single byte data instead of double byte data in the 
 
application. For example, if you are using UCS-2 data and 
 
SQL_C_WCHAR C_Type, switch to using Unicode 1208 codepage and 
 
data,  and SQL_C_CHAR C_Type in the application.

DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

Problem was first fixed in DB2 UDB Version 9.7 Fix Pack 3.

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC69142 
Nachfolger : 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

04.06.2010
27.09.2010
27.09.2010

9.7.FP3