DB2 - Problembeschreibung
Problem IC63038 | Status: Geschlossen |
DB2LOOK FAILS TO INSERT A COMMA INCASE THERE IS NO CONSECUTIVE ELEMENT CREATED FOR COMPONENTS LISTED. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
db2look fails to insert a comma incase there is no consecutive element created for COMPONENTS listed. EX: CREATE SECURITY LABEL COMPONENT "COMPONENT_01" SET {'001', '002', '003'}; CREATE SECURITY LABEL COMPONENT "COMPONENT_02" SET {'004', '005', '006'}; CREATE SECURITY LABEL COMPONENT "COMPONENT_03" SET {'007', '008', '009'}; If you specify the elements for components COMPONENT_01 and COMPONENT_03 as follows: CREATE SECURITY LABEL "SEC_LABEL"."LABEL_NAME" COMPONENT "COMPONENT_01" '001', COMPONENT "COMPONENT_03" '008'; then db2look will fail to insert a comma for components listed causing error SQL0104N be printed in db2look output and bad syntax like as following: CREATE SECURITY LABEL "SEC_LABEL"."LABEL_NAME" COMPONENT "COMPONENT_01" '001' COMPONENT "COMPONENT_03" '008'; However, if you specify all consecutive component elements, db2look will generate the correct DDL: CREATE SECURITY LABEL "SEC_LABEL"."LABEL_NAME" COMPONENT "COMPONENT_01" '001', COMPONENY "COMPONENT_02" '004', COMPONENT "COMPONENT_03" '008'; | |
Problem-Zusammenfassung: | |
DB2LOOK FAILS TO INSERT A COMMA INCASE THERE IS NO CONSECUTIVE ELEMENT CREATED FOR COMPONENTS LISTED. | |
Local-Fix: | |
No local Fix | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows | |
Lösung | |
It is fixed in db2 V9.7 FP2 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 08.09.2009 06.07.2010 06.07.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP2 | |
Problem behoben lt. FixList in der Version | |
9.7.0.2 |