|
Problem IC89361
|
Status: Geschlossen |
FOR INSERTED ROWS, THE SELECT QUERY AGAINST HOST SERVER RETURNS DATETIME TYPE DATA AS 0. |
| Produkt: |
DB2 CONNECT / DB2CONNCT / 970 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
****************************************************************
* 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: |
|
| verfügbare FixPacks: |
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
|
| Lösung |
db2_v97fp8 contains fix of this issue. After fix, the correct
output will display. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 03.01.2013
01.04.2013
01.04.2013 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.8
|
 |
