|
Problem IC64059
|
Status: Closed |
USING MULTIPLE QUOTES IN CLI INSERT SCRIPT BEFORE DATE FIELD (WITH ESCAPE FIELD) FAILS. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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. |
| Problem Summary: |
****************************************************************
* 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 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
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
|
| Solution |
Fixed in v97fp1.
USING MULTIPLE QUOTES IN CLI INSERT SCRIPT BEFORE DATE FIELD
(WITH ESCAPE FIELD) WILL PASS. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 22.10.2009
24.02.2010
24.02.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP1
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.1
|
 |
