home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC77954 Status: Geschlossen

SQL0303N IS RETURNED WHEN SELECTING VALUES OF ZOS DATA TYPES
TIMESTAMP_TIMEZONE

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
SQL0303N is returned when selecting values of zOS data types 
TIMESTAMP_TIMEZONE 
We dont get the error in V9.7 FP1 
 
CREATE TABLE 
TBL1 
( 
ID INTEGER 
,TMSTZ_12 TIMESTAMP (12) WITH TIMEZONE 
,TMS_12 TIMESTAMP (12) 
) 
 
db2 select TMSTZ_12 from TBL1 
 
TMSTZ_12 
 
 
---------------------------------------------------------------- 
---------------- 
---------------------------------------------------------------- 
---------------- 
 
SQL0303N  A value cannot be assigned to a host variable in the 
SELECT, VALUES, 
FETCH or assignment statement because the data types are not 
compatible. 
SQLSTATE=42806
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 V9.7                                                     * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* SQL0303N is returned when selecting values of zOS data types * 
* TIMESTAMP_TIMEZONE                                           * 
* We dont get the error in V9.7 FP1                            * 
*                                                              * 
* CREATE TABLE                                                 * 
* TBL1                                                         * 
* (                                                            * 
* ID INTEGER                                                   * 
* ,TMSTZ_12 TIMESTAMP (12) WITH TIMEZONE                       * 
* ,TMS_12 TIMESTAMP (12)                                       * 
* )                                                            * 
*                                                              * 
* db2 select TMSTZ_12 from TBL1                                * 
*                                                              * 
* TMSTZ_12                                                     * 
*                                                              * 
*                                                              * 
* ------------------------------------------------------------ * 
* ----                                                         * 
* ----------------                                             * 
* ------------------------------------------------------------ * 
* ----                                                         * 
* ----------------                                             * 
*                                                              * 
* SQL0303N  A value cannot be assigned to a host variable in   * 
* the                                                          * 
* SELECT, VALUES,                                              * 
* FETCH or assignment statement because the data types are not * 
* compatible.                                                  * 
* SQLSTATE=42806                                               * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to V9.7 FP6                                          * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
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 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
First fixed in in V9.7 FP6
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC84437 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
05.08.2011
06.06.2012
06.06.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP6
Problem behoben lt. FixList in der Version
9.7.0.6 FixList