
CREATE MULTISET TABLE DWHFRT.STAMP_EVT_VOL_GRP ,NO FALLBACK ,
     NO BEFORE JOURNAL,
     NO AFTER JOURNAL,
     CHECKSUM = DEFAULT,
     DEFAULT MERGEBLOCKRATIO
     (
      IDT_EVT CHAR(32) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'ID evt' NOT NULL,
      IDT_VOL CHAR(32) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'Flight ID' NOT NULL,
      DAT_CRN_ODS TIMESTAMP(0) TITLE 'Timestamp when row was imported to ODS' NOT NULL,
      DAT_MDF TIMESTAMP(0) TITLE 'Last modified Time Stamp' COMPRESS ,
      DAT_CRN_DWH DATE FORMAT 'YYYYMMDD' TITLE 'DWH creation date' NOT NULL)
PRIMARY INDEX PI_STAMP_EVT_VOL_GRP ( IDT_EVT ,IDT_VOL );


SELECT	IDT_EVT, IDT_VOL, DAT_CRN_ODS, DAT_MDF, DAT_CRN_DWH
FROM	DWHFRT.STAMP_EVT_VOL_GRP