CREATE TABLE DOCS.MAKETS
 (MAK_ID  INTEGER         NOT NULL  GENERATED BY DEFAULT
    AS IDENTITY (START WITH  1 , INCREMENT BY  1 , CACHE  5 , MINVALUE  1 , MAXVALUE  2147483647 , NO CYCLE, NO ORDER),
  MSG_ID  SMALLINT        NOT NULL,
  ID_DPL  CHARACTER( 3 )    NOT NULL,
  DDMM    CHARACTER( 4 )    NOT NULL,
  NUM_MAK CHARACTER( 3 )    NOT NULL
 )
  DATA CAPTURE NONE
  IN TSMAKETS
  PARTITIONING KEY
   (MAK_ID
   ) USING HASHING
  NOT LOGGED INITIALLY;

ALTER TABLE DOCS.MAKETS
  LOCKSIZE ROW
  APPEND OFF
  NOT VOLATILE;

ALTER TABLE DOCS.MAKETS
  ADD CONSTRAINT XPK_MAKETS PRIMARY KEY
   (MAK_ID
   );


CREATE TABLE DOCS.MAKETS_REC
 (MAK_ID    INTEGER,
  REC_NUM   SMALLINT        NOT NULL,
  MM_NUM    SMALLINT        NOT NULL,
  BW_DT     CHARACTER( 6 )    NOT NULL,
  VT        CHARACTER( 1 )    NOT NULL,
  VD        CHARACTER( 2 )    NOT NULL,
  LOC_MOD1  CHARACTER( 3 )    NOT NULL,
  SEC_NUM1  CHARACTER( 8 )    NOT NULL,
  LMIN1     INTEGER         NOT NULL,
  LOC_MOD2  CHARACTER( 3 ),
  SEC_NUM2  CHARACTER( 8 ),
  LMIN2     INTEGER,
  LOC_MOD3  CHARACTER( 3 ),
  SEC_NUM3  CHARACTER( 8 ),
  LMIN3     INTEGER,
  LOC_MOD4  CHARACTER( 3 ),
  SEC_NUM4  CHARACTER( 8 ),
  LMIN4     INTEGER,
  LOC_MOD5  CHARACTER( 3 ),
  SEC_NUM5  CHARACTER( 8 ),
  LMIN5     INTEGER,
  ORL       INTEGER
 )
  DATA CAPTURE NONE
  IN TSMAKETS
  PARTITIONING KEY
   (MAK_ID
   ) USING HASHING
  NOT LOGGED INITIALLY;

ALTER TABLE DOCS.MAKETS_REC
  LOCKSIZE ROW
  APPEND OFF
  NOT VOLATILE;

ALTER TABLE DOCS.MAKETS_REC
  ADD CONSTRAINT R_1039 FOREIGN KEY
   (MAK_ID
   )
    REFERENCES DOCS.MAKETS
     (MAK_ID
     )
    ON DELETE CASCADE
    ENFORCED
    ENABLE QUERY OPTIMIZATION;

delete from DOCS.MAKETS where MAK_ID= 1 ;