DB2 - Problembeschreibung
Problem IC65656 | Status: Geschlossen |
DB2LOOK GENERATE INCORRECT VIEW/PROCEDURE/FUNCTION/TRIGGER ... D DL IF COMMENT CONTAINING A 'REPLACE' KEYWORD HAS BEEN ADDED AS P | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
Problem is reproducible by running the following DDL: db2start ; create db repro ; connect to repro ; CREATE TABLE "LSOTFORM_C" ( "MANDT" VARCHAR(9) NOT NULL WITH DEFAULT '000' , "TFORM" VARCHAR(12) NOT NULL WITH DEFAULT '0000' , "TFORMP" VARCHAR(12) NOT NULL WITH DEFAULT '0000' ) VALUE COMPRESSION ; CREATE TABLE "LSOTFORMT_C" ( "MANDT" VARCHAR(9) NOT NULL WITH DEFAULT '000' , "TFORM" VARCHAR(12) NOT NULL WITH DEFAULT '0000' , "SPRAS" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "TXTSHORT" VARCHAR(60) NOT NULL WITH DEFAULT ' ' , "TXTSING" VARCHAR(120) NOT NULL WITH DEFAULT ' ' , "TXTPLUR" VARCHAR(120) NOT NULL WITH DEFAULT ' ' ) VALUE COMPRESSION ; CREATE TABLE "LSOTFORMP_C" ( "TFORMP" VARCHAR(12) NOT NULL WITH DEFAULT '0000' , "OBJTYPE" VARCHAR(6) NOT NULL WITH DEFAULT ' ' , "OBJTYPETYPE" VARCHAR(6) NOT NULL WITH DEFAULT ' ' , "RELATION" VARCHAR(12) NOT NULL WITH DEFAULT ' ' , "GENTRAIN" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "TYPE" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "SCHEDULE_DEP" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "LOCATION_DEP" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "RESOURCE_DEP" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "MEDIA_STORED" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "LA_WRITE" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "TAC_WRITE" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "MASSN" VARCHAR(12) NOT NULL WITH DEFAULT ' ' , "MASSN_TRAINING" VARCHAR(12) NOT NULL WITH DEFAULT ' ' , "CMD_BOOKBE" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "CMD_REBOOKBE" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "CMD_PREBOOKBE" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "CMD_REPLACEBE" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "CMD_CANCELBE" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "CMD_BOOK_LISTBE" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "CMD_PREBK_LSTBE" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "CMD_BK_ATTBE" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "CMD_PREBK_TRNGBE" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "CMD_CREATEBE" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "CMD_CRRP_HISTOBE" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "CMD_FOLLOWUPBE" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "CMD_BILLINGBE" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "CMD_ACTIVALLBE" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "CMD_SCHEDULEBE" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "CMD_MODIFYBE" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "CMD_PLANBE" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "CMD_DISPLAYBE" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "CMD_WEBLINKBE" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "CMD_KNLLINKBE" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "CMD_CORRESPBE" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "CMD_RESO_SHOWBE" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "CMD_LOCKBE" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "CMD_FIXBE" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "CMD_COST_TRANBE" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "CMD_PRICE_PROPBE" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "CMD_INS_ALLOCBE" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "CMD_MATERIALBE" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "CMD_BOOKFE" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "CMD_REBOOKFE" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "CMD_PREBOOKFE" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "CMD_REPLACEFE" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "CMD_CANCELFE" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "CMD_BOOK_LISTFE" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "CMD_PREBK_LSTFE" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "CMD_BK_ATTFE" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "CMD_PREBK_TRNGFE" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "CMD_CREATEFE" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "CMD_CRRP_HISTOFE" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "CMD_FOLLOWUPFE" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "CMD_BILLINGFE" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "CMD_ACTIVALLFE" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "CMD_SCHEDULEFE" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "CMD_MODIFYFE" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "CMD_PLANFE" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "CMD_DISPLAYFE" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "CMD_WEBLINKFE" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "CMD_KNLLINKFE" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "CMD_CORRESPFE" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "CMD_RESO_SHOWFE" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "CMD_LOCKFE" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "CMD_FIXFE" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "CMD_COST_TRANFE" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "CMD_PRICE_PROPFE" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "CMD_INS_ALLOCFE" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , "CMD_MATERIALFE" VARCHAR(3) NOT NULL WITH DEFAULT ' ' ) VALUE COMPRESSION ; CREATE VIEW "U_37180C" ( "MANDT", "TFORM", "SPRAS", "TXTSHORT", "TXTSING", "TXTPLUR", "TFORMP", "OBJTYPE", "OBJTYPETYPE", "RELATION", "GENTRAIN", "TYPE", "SCHEDULE_DEP", "LOCATION_DEP", "MEDIA_STORED", "LA_WRITE", "TAC_WRITE", "MASSN", "CMD_BOOKBE", "CMD_REBOOKBE", "CMD_PREBOOKBE", "CMD_REPLACEBE", "CMD_CANCELBE", "CMD_BOOK_LISTBE", "CMD_PREBK_LSTBE", "CMD_BK_ATTBE", "CMD_PREBK_TRNGBE", "CMD_CREATEBE", "CMD_CRRP_HISTOBE", "CMD_FOLLOWUPBE", "CMD_BOOKFE", "CMD_REBOOKFE", "CMD_PREBOOKFE", "CMD_REPLACEFE", "CMD_CANCELFE", "CMD_BOOK_LISTFE", "CMD_PREBK_LSTFE", "CMD_BK_ATTFE", "CMD_PREBK_TRNGFE", "CMD_CREATEFE", "CMD_CRRP_HISTOFE", "CMD_FOLLOWUPFE" ) AS SELECT T0001."MANDT", T0001."TFORM", T0002."SPRAS", T0002."TXTSHORT", T0002."TXTSING", T0002."TXTPLUR", T0001."TFORMP", T0003."OBJTYPE", T0003."OBJTYPETYPE", T0003."RELATION", T0003."GENTRAIN", T0003."TYPE", T0003."SCHEDULE_DEP" , T0003."LOCATION_DEP", T0003."MEDIA_STORED", T0003."LA_WRITE", T0003."TAC_WRITE", T0003."MASSN", T0003."CMD_BOOKBE", T0003."CMD_REBOOKBE", T0003."CMD_PREBOOKBE", T0003."CMD_REPLACEBE", T0003."CMD_CANCELBE", T0003."CMD_BOOK_LISTBE", T0003."CMD_PREBK_LSTBE", T0003."CMD_BK_ATTBE", T0003."CMD_PREBK_TRNGBE", T0003."CMD_CREATEBE", T0003."CMD_CRRP_HISTOBE", T0003."CMD_FOLLOWUPBE", T0003."CMD_BOOKFE", T0003."CMD_REBOOKFE", T0003."CMD_PREBOOKFE", T0003."CMD_REPLACEFE", T0003."CMD_CANCELFE", T0003."CMD_BOOK_LISTFE", T0003."CMD_PREBK_LSTFE", T0003."CMD_BK_ATTFE", T0003."CMD_PREBK_TRNGFE", T0003."CMD_CREATEFE", T0003."CMD_CRRP_HISTOFE", T0003."CMD_FOLLOWUPFE" FROM "LSOTFORM_C" T0001, "LSOTFORMT_C" T0002, "LSOTFORMP_C" T0003 WHERE T0001."MANDT" = T0002."MANDT" AND T0001."TFORM" = T0002."TFORM" AND T0003."TFORMP" = T0001."TFORMP" ; and the running db2look -d repro -e in the output, the definition for the view will be incorrect. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Software * **************************************************************** * PROBLEM DESCRIPTION: * * db2look was generating incorrect DDL statement for * * procedure, function , views, trigger for '-cor' option in * * case the statement contain a replace word as part of comment * **************************************************************** * RECOMMENDATION: * * customer has to upgrade to v97 fp2 version * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows | |
Lösung | |
the problem has been solved in v97 fp2 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC66954 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 19.01.2010 23.04.2010 23.04.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP2 | |
Problem behoben lt. FixList in der Version | |
9.7.0.2 |