DB2 FOR LUW / DB2FORLUW / 970 - DB2

Error description: 
 
Inserting data in table  through cli  scripts fails - in case it 
is using escape date field with multiple quotes preceeding it. 
 
Example: 
sqlprepare 1 "insert into t1(c1, c2) values ('hel''''''''lo', 
{d'2006-12-12'})" -3 
 
Here multiple quotes are used before ODBC escaped date like {d 
'2006-12-02'}. 
 
And error as follows with happen. 
 
SQL0104N  An unexpected token "{d '2006-12-02' }" was 
 found following "''''''''".  Expected tokens may 
include:  "<rvc_element>".  SQLSTATE=42601 
 
As soon as an ODBC escaped date like {d '2006-12-02' } follows 
multiple quotes, the escape sequence is not replaced.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* USING MULTIPLE  QUOTES IN CLI INSERT SCRIPT BEFORE DATE      * 
* FIELD                                                        * 
* (WITH ESCAPE FIELD) FAILS.                                   * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgarde to v97fp1 or later                                   * 
****************************************************************

DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
 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 9a for Linux, UNIX, and Windows
 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 10 for Linux, UNIX, and Windows
 

Fixed in v97fp1. 
USING MULTIPLE QUOTES IN CLI INSERT SCRIPT BEFORE DATE FIELD 
(WITH ESCAPE FIELD) WILL PASS.

keiner bekannt / siehe Local-Fix

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

22.10.2009
24.02.2010
24.02.2010

9.7.FP1