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. |
