DB2 - Problembeschreibung
Problem IC64016 | Status: Geschlossen |
SQL -104 (SQL0104N) WHEN USING CONTROL CENTER CONNECTING TO EBCDIC DB ON Z/OS WITH OBJECT NAMES IN UNICODE | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
When using Control Center to connect to a EBCDIC database on Z/OS with object names in Unicode we get SQL -104 when sending special characters to the host: To Reproduce: 1. On the Z/OS database we have a Table which name is the character for the Greek letter Omega in capitals: $ cat greek2 create table ""(c int); $ od -cx greek2 0000000 c r e a t e t a b l e " 6372 6561 7465 2074 6162 6c65 2022 cea9 0000020 " ( c i n t ) ; \n 2228 6320 696e 7429 3b0a 0000032 0xcea9 is the Character code for ? (Omega in capitals) db2 "select hex(name) from sysibm.systables " shows CEA9 2. From Control Center connect to the Z/Os database and --> right mouse key on table schema.<omega> --> push down menu query: select * from schema.<omega> will show in the commend editor. If we run the above query we get SQL -104. select * from schema."<omega> " using quotes on the table name the query runs successful Control Center is not adding "quotes" when sending the request to Z/OS with special characters (it works correctly in DB2 LUW). 3. Using the option Open for the table gives SQL -104 and there is no way of changing the request by the user in command editor. | |
Problem-Zusammenfassung: | |
Local-Fix: | |
Use "" quotes to correct query in Commad Editor before sending to the host: select * from schema."<omega>" instead of select * from schema.<omega> | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Kommentar | |
using close code ISV as the rquired colse code CAN won't work | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 22.10.2009 17.02.2010 17.02.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
9.7.0.1 |