CREATE MULTISET TABLE DWHFRT.STAMP_EVT_VOL ,NO FALLBACK ,
     NO BEFORE JOURNAL,
     NO AFTER JOURNAL,
     CHECKSUM = DEFAULT,
     DEFAULT MERGEBLOCKRATIO
     (
      IDT_EVT CHAR(32) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'Idt evt' NOT NULL,
      DAT_CRN_ODS TIMESTAMP(0) TITLE 'Timestamp when row was imported to ODS' NOT NULL,
      TYP_MVT CHAR(2) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'Type mvt' COMPRESS ,
      COD_CIE_TSP CHAR(3) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'Transport company' COMPRESS ,
      NUM_TSP CHAR(4) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'Transport Number' COMPRESS ,
      SFX_OPS CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'Operational Suffix' COMPRESS ,
      ESC_ORI CHAR(3) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'Origin Station' COMPRESS ,
      ESC_DST CHAR(3) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'Dest. Station' COMPRESS ,
      DAT_DEB_PRV DATE FORMAT 'YYYYMMDD' TITLE 'Planned start date' COMPRESS ,
      DAT_DEB DATE FORMAT 'YYYYMMDD' TITLE 'Start date' COMPRESS ,
      DAT_UTC_DCK TIMESTAMP(0) TITLE 'Dock Date UTC' COMPRESS ,
      DAT_LOC_DCK TIMESTAMP(0) TITLE 'Dock Date Local' COMPRESS ,
      DAT_UTC_VOL TIMESTAMP(0) TITLE 'Flight Date UTC' COMPRESS ,
      DAT_LOC_VOL TIMESTAMP(0) TITLE 'Flight Date Local' COMPRESS ,
      DAT_MDF TIMESTAMP(0) TITLE 'Last modified Time Stamp' COMPRESS ,
      DAT_CRN_DWH DATE FORMAT 'YYYYMMDD' TITLE 'DWH creation date' NOT NULL,
      DAT_DEB_PRV_TS TIMESTAMP(0) TITLE 'Planned start date Timestamp format' COMPRESS ,
      DAT_DEB_TS TIMESTAMP(0) TITLE 'Start date Timestamp format' COMPRESS )
PRIMARY INDEX PI_STAMP_EVT_VOL ( IDT_EVT );



SELECT	IDT_EVT, DAT_CRN_ODS, TYP_MVT, COD_CIE_TSP, NUM_TSP, SFX_OPS,
		ESC_ORI,
		ESC_DST,
		DAT_DEB_PRV,
		DAT_DEB,
		DAT_UTC_DCK,
		DAT_LOC_DCK,
		DAT_UTC_VOL,
		DAT_LOC_VOL,
		DAT_MDF,
		DAT_CRN_DWH,
		DAT_DEB_PRV_TS,
		DAT_DEB_TS
FROM	DWHFRT.STAMP_EVT_VOL

