zOs/TX/PER26DDL

   DROP TABLESPACE  $db.aper26 ;
   COMMIT ;
   ;
$@[
if $phase >= 1 then $@=[
--
 SET CURRENT SQLID = 'S100447';


    CREATE TABLESPACE APER26
           IN $db
           BUFFERPOOL BP2
           DSSIZE 16G
           CLOSE NO
           LOCKMAX SYSTEM
           SEGSIZE 64
           DEFINE YES
           LOGGED
           LOCKSIZE ANY
           MAXROWS 255
           CCSID EBCDIC
           NUMPARTS $parts
                     USING STOGROUP GSMS
                                    PRIQTY -1
                                    SECQTY -1
                                    ERASE NO
                     PCTFREE 5
                     FREEPAGE 5
                     GBPCACHE CHANGED
                     COMPRESS YES
                     TRACKMOD YES
;

    CREATE TABLE $creator.TPer26
        (
         TKKEY DECIMAL(13, 0)
                                                        NOT NULL
        ,VERFALL DATE
                                                        NOT NULL
  WITH DEFAULT '0001-01-01'
        ,BOERSE CHARACTER(12) FOR SBCS DATA
                                                        NOT NULL
        ,WHRG CHARACTER(4) FOR SBCS DATA
                                                        NOT NULL
        ,STATUS CHARACTER(1) FOR SBCS DATA
                                                        NOT NULL
        ,KURSDATUM DATE
                                                        NOT NULL
        ,MUT_TIMESTAMP TIMESTAMP (6) WITHOUT TIME ZONE
                                                        NOT NULL
  WITH DEFAULT
        ,TK_KURSTYP CHARACTER(5) FOR SBCS DATA
                                                        NOT NULL
  WITH DEFAULT
        ,TK_ZUSATZ CHARACTER(5) FOR SBCS DATA
                                                        NOT NULL
  WITH DEFAULT
        ,CS_KA_NUM CHARACTER(2) FOR SBCS DATA
                                                        NOT NULL
  WITH DEFAULT
        ,KURS_LIEFERUNG DECIMAL(31, 15)
                                                        NOT NULL
  WITH DEFAULT
        ,KURS_UMRECHNUNG DECIMAL(31, 15)
                                                        NOT NULL
  WITH DEFAULT
        ,MENGE DECIMAL(31, 15)
                                                        NOT NULL
  WITH DEFAULT
        ,BOERSE_TK CHARACTER(12) FOR SBCS DATA
                                                        NOT NULL
  WITH DEFAULT
        ,ERSTELLUNG TIMESTAMP (6) WITHOUT TIME ZONE
                                                        NOT NULL
  WITH DEFAULT
        ,QUELLE CHARACTER(10) FOR SBCS DATA
                                                        NOT NULL
  WITH DEFAULT
        ,LOG_EINTRAG CHARACTER(8) FOR SBCS DATA
                                                        NOT NULL
  WITH DEFAULT USER
        ,INSTRAD CHARACTER(8) FOR SBCS DATA
                                                        NOT NULL
  WITH DEFAULT
        ,KS_BPL_ST CHARACTER(1) FOR SBCS DATA
                                                        NOT NULL
  WITH DEFAULT '0'
        ,KS_BPL_HT CHARACTER(1) FOR SBCS DATA
                                                        NOT NULL
  WITH DEFAULT '0'
        ,KS_BPL_KS CHARACTER(1) FOR SBCS DATA
                                                        NOT NULL
  WITH DEFAULT '0'
        ,KS_ALT_KS CHARACTER(1) FOR SBCS DATA
                                                        NOT NULL
  WITH DEFAULT '0'
        ,KS_BPL_HA CHARACTER(1) FOR SBCS DATA
                                                        NOT NULL
  WITH DEFAULT '0'
        ,KS_AIS_SP CHARACTER(1) FOR SBCS DATA
                                                        NOT NULL
  WITH DEFAULT '0'
        ,KS_BPL_IN CHARACTER(1) FOR SBCS DATA
                                                        NOT NULL
  WITH DEFAULT '0'
        ,KS_BPL_SP CHARACTER(1) FOR SBCS DATA
                                                        NOT NULL
  WITH DEFAULT '0'
        ,EXCODE CHARACTER(2) FOR SBCS DATA
                                                        NOT NULL
  WITH DEFAULT '00'
        ,CONSTRAINT TKKEY PRIMARY KEY
        (TKKEY
        ,VERFALL
        ,BOERSE
        ,WHRG
        ,STATUS
        ,KURSDATUM
        ,MUT_TIMESTAMP
        )
        )
        IN $db.aPer26
   APPEND NO
   NOT VOLATILE CARDINALITY
   DATA CAPTURE CHANGES
   AUDIT NONE
   CCSID EBCDIC
   PARTITION BY RANGE
        (TKKEY NULLS LAST ASC
        )
        ( PARTITION 1 ending   (     1000000000 )
$do px=2 to $parts $@=[
        , PARTITION $px ending ( ${px}000000000 )
$]
        );

    CREATE        UNIQUE INDEX $creator.iper26
           ON $creator.Tper26
          (TKKEY ASC
          ,VERFALL ASC
          ,BOERSE ASC
          ,WHRG ASC
          ,STATUS ASC
          ,KURSDATUM DESC
          ,MUT_TIMESTAMP DESC
          )
           CLUSTER
           PARTITIONED
           DEFINE YES
           COMPRESS NO
           BUFFERPOOL BP1
           CLOSE NO
           DEFER NO
           COPY NO
           USING STOGROUP GSMS
               PRIQTY -1
               SECQTY -1
               ERASE NO
               FREEPAGE 0
               PCTFREE 5
               GBPCACHE CHANGED
;
commit;
$]
$]