SET CURRENT SQLID = 'DBCLSYAD';
     CREATE DATABASE
       D00LJCOR
         BUFFERPOOL BP10
         INDEXBP BP30
         STOGROUP SG000000
         CCSID EBCDIC
     ;
     CREATE
      TABLESPACE TPLJG000
         IN D00LJCOR
         USING STOGROUP SG000000
         PRIQTY -1
         SECQTY -1
         ERASE NO
         FREEPAGE 0
         PCTFREE 5
         GBPCACHE CHANGED
         COMPRESS YES
         TRACKMOD YES
         LOGGED
         DSSIZE 64 G
         SEGSIZE 64
         MAXPARTITIONS 1
         BUFFERPOOL BP10
         LOCKSIZE PAGE
         LOCKMAX 0
         CLOSE YES
         CCSID EBCDIC
         MAXROWS 255
         INSERT ALGORITHM 0
     ;
--     SET CURRENT SQLID = 'PS7E';
     CREATE TABLE
       T7.TBBBZ
        (
        MANDANT   INTEGER NOT NULL
       ,VTR_NR   INTEGER NOT NULL
       ,P_ID   INTEGER NOT NULL
       ,BZ_ART_SKZ   INTEGER NOT NULL
       ,WIRKAB   INTEGER NOT NULL
       ,CREATE_DAT   TIMESTAMP NOT NULL
       ,ANSCHRIFT_ID   INTEGER NOT NULL
       ,ANT_BTR   DECFLOAT(34) NOT NULL WITH DEFAULT 0
       ,ANT_BTR_PROZ   DECFLOAT(34) NOT NULL
       ,ANT_VERLAUF_JN   CHAR(1) NOT NULL
         FOR SBCS DATA
       ,BANK_ID   INTEGER NOT NULL
       ,BZ_PERSONAL_NR   CHAR(10) NOT NULL
         FOR SBCS DATA
       ,BZ_ZUS_SKZ   INTEGER NOT NULL
       ,FAELLIG_SKZ   INTEGER NOT NULL
       ,GEHALTS_NR   CHAR(20) NOT NULL WITH DEFAULT '-'
         FOR SBCS DATA
       ,INKA_SOND_VW_SKZ   CHAR(2) NOT NULL
         FOR SBCS DATA
       ,MASCH_AE_JN   CHAR(1) NOT NULL
         FOR SBCS DATA
       ,SAMMEL_NR   INTEGER NOT NULL
       ,WBZ_PERSONAL_NR   CHAR(10) NOT NULL
         FOR SBCS DATA
       ,WBZ_P_ID   INTEGER NOT NULL
       ,WIRKBIS   INTEGER NOT NULL
       ,ZAHLWEG_SKZ   INTEGER NOT NULL
       ,CREATE_GEVO_NR   INTEGER NOT NULL
       ,ABGRENZ_GEVO_NR   INTEGER NOT NULL
       ,UNGUELTIG_GEVO_NR   INTEGER NOT NULL
       ,WIRKBIS_HIST   INTEGER NOT NULL
       ,FREI_FELD_NVP   VARCHAR(40) NOT NULL
         FOR SBCS DATA
       ,ROLLEN_ID   INTEGER NOT NULL WITH DEFAULT 0
        ,
         CONSTRAINT PK_BBZ
         PRIMARY KEY
         (
          MANDANT
          ,VTR_NR
          ,P_ID
          ,BZ_ART_SKZ
          ,WIRKAB
          ,CREATE_DAT
         )
        )
         IN D00LJCOR.TPLJG000
         WITH RESTRICT ON DROP
         CCSID EBCDIC
         NOT VOLATILE
         APPEND NO
         NO KEY LABEL
     ;
  LABEL ON TABLE T7.TBBBZ
  IS 'LC00050T'
  ;
--     SET CURRENT SQLID = USER;
     CREATE
        INDEX T7.I2BBZ
       ON T7.TBBBZ
        (
         MANDANT ASC
        ,VTR_NR ASC
        ,CREATE_DAT ASC
        )
         USING STOGROUP SG000000
         PRIQTY -1
         SECQTY -1
         ERASE NO
         FREEPAGE 0
         PCTFREE 5
         GBPCACHE CHANGED
         NOT CLUSTER
         BUFFERPOOL BP30
         CLOSE YES
         COPY NO
         PIECESIZE 1 G
         COMPRESS NO
     ;
     CREATE
        INDEX T7.I4BBZ
       ON T7.TBBBZ
        (
         MANDANT ASC
        ,P_ID ASC
        ,CREATE_DAT ASC
        )
         USING STOGROUP SG000000
         PRIQTY -1
         SECQTY -1
         ERASE NO
         FREEPAGE 0
         PCTFREE 5
         GBPCACHE CHANGED
         NOT CLUSTER
         BUFFERPOOL BP30
         CLOSE YES
         COPY NO
         PIECESIZE 1 G
         COMPRESS NO
     ;
     CREATE
        INDEX T7.I5BBZ
       ON T7.TBBBZ
        (
         MANDANT ASC
        ,SAMMEL_NR ASC
        ,CREATE_DAT ASC
        )
         USING STOGROUP SG000000
         PRIQTY -1
         SECQTY -1
         ERASE NO
         FREEPAGE 0
         PCTFREE 5
         GBPCACHE CHANGED
         NOT CLUSTER
         BUFFERPOOL BP30
         CLOSE YES
         COPY NO
         PIECESIZE 1 G
         COMPRESS NO
     ;
     CREATE UNIQUE
        INDEX T7.PK_BBZ
       ON T7.TBBBZ
        (
         MANDANT ASC
        ,VTR_NR ASC
        ,P_ID ASC
        ,BZ_ART_SKZ ASC
        ,WIRKAB ASC
        ,CREATE_DAT ASC
        )
         USING STOGROUP SG000000
         PRIQTY -1
         SECQTY -1
         ERASE NO
         FREEPAGE 0
         PCTFREE 5
         GBPCACHE CHANGED
         NOT CLUSTER
         BUFFERPOOL BP30
         CLOSE YES
         COPY NO
         PIECESIZE 1 G
         COMPRESS NO
     ;
     CREATE
        INDEX T7.X2BBZ
       ON T7.TBBBZ
        (
         MANDANT ASC
        ,VTR_NR ASC
        ,WIRKAB ASC
        ,WIRKBIS ASC
        ,MASCH_AE_JN ASC
        )
         USING STOGROUP SG000000
         PRIQTY -1
         SECQTY -1
         ERASE NO
         FREEPAGE 0
         PCTFREE 5
         GBPCACHE CHANGED
         NOT CLUSTER
         BUFFERPOOL BP30
         CLOSE YES
         COPY NO
         PIECESIZE 1 G
         COMPRESS NO
     ;
     CREATE
        INDEX T7.X3BBZ
       ON T7.TBBBZ
        (
         MANDANT ASC
        ,VTR_NR ASC
        ,P_ID ASC
        ,WIRKAB ASC
        ,WIRKBIS ASC
        )
         USING STOGROUP SG000000
         PRIQTY -1
         SECQTY -1
         ERASE NO
         FREEPAGE 0
         PCTFREE 5
         GBPCACHE CHANGED
         NOT CLUSTER
         BUFFERPOOL BP30
         CLOSE YES
         COPY NO
         PIECESIZE 1 G
         COMPRESS NO
     ;