|
Problem IC89361
|
Status: Closed |
FOR INSERTED ROWS, THE SELECT QUERY AGAINST HOST SERVER RETURNS DATETIME TYPE DATA AS 0. |
| product: |
DB2 CONNECT / DB2CONNCT / 970 - DB2 |
| Problem description: |
For Inserted rows, the select query against Host Server returns
datetime type data as 0. The code page conversion at the time of
bind out for inserted rows is causing this issue.
Below result shows the expected output and current output. This
issue is in V97FP7 only.
< Element [11] Contents: Year: 2001, Month: 12, Day: 31
< Hour: 12, Minute: 30, Second: 10, Fraction: 123000
---
> Element [11] Contents: Year: 0, Month: 0, Day: 0
> Hour: 0, Minute: 0, Second: 0, Fraction: 0
This difference is seen as a part of the output of API
> list memarray 1 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Against host server, when date-time type data is inserted *
* and selected for the same statement handle in mem-array *
* without commit using SQLFetchScroll. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to db2_v97fp8 or later release. *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
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
|
| Solution |
db2_v97fp8 contains fix of this issue. After fix, the correct
output will display. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 03.01.2013
01.04.2013
01.04.2013 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.8
|
 |
