DB2 - Problembeschreibung
Problem IC76188 | Status: Geschlossen |
DB2DART /DDEL DOES NOT DOUBLE DOUBLE QUOTE CHARACTERS CONTAINED IN CHARACTER DATA COLUMNS | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
db2dart /ddel can be used to export data from tables that are for some reason unavailable. If the data contains a double quote character i.e. " , then an export file should double this character to make the distinction with the default delimiter. The db2 export command does this. a simple example to illustrate the issue : create table tab1 ( col1 char(20 ) ); insert into tab1 values ( 'ab"cd' ) ; export to file.del of del select * from tab1; cat file.del : "ab""cd " select tid, fid from sysibm.systables where name = 'TAB1' ; TID FID ------ ------ 3 10 db2dart sample /ddel 10,3,0,1 $ cat /home/db2inst3/sqllib/db2dump/DART0000/TS3T10.DEL "ab"cd " the lack of doubling in the output file produced by db2dart /ddel prevents the data in the file from being imported correctly. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * db2dart /ddel unable to export data containing double quotes * **************************************************************** * RECOMMENDATION: * * Upgrade DB2 to V9.7 Fix Pack 5 * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows | |
Lösung | |
This problem has first been fixed in V9.7 Fix Pack 5 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 05.05.2011 22.12.2011 22.12.2011 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP5 | |
Problem behoben lt. FixList in der Version | |
9.7.0.5 |