zOs/TX/PER12DDL

------------$-{right(userid() sysvar(sysnode) date(s) time(), 60, '-')}
-- testCase $dsn
-- env      $env      phase $phase
-- subsys   $subsys     db $db       creator $creator
------------------------------------------------------------------------
---||| begin ddl testcase $mbr env $env phase $phase
SET CURRENT SQLID='S100447';
drop tablespace $db.aper12;
commit;
------------------------------------------------------------------------
CREATE TABLESPACE aper12
    IN $db
    USING STOGROUP GSMS
    PRIQTY -1 SECQTY -1
    ERASE  NO
    FREEPAGE 0 PCTFREE 10
    GBPCACHE CHANGED
    TRACKMOD YES
    segsize 64
    BUFFERPOOL BP2
    LOCKSIZE ANY
    LOCKMAX SYSTEM
    CLOSE YES
    COMPRESS YES
    CCSID      EBCDIC
    DEFINE YES
    MAXROWS 255
;  ---------------------------------------------------------------------
  CREATE TABLE $creator.tper12
     ( i1 int not null
     , i2 smallint not null
     , j1 int not null
     , j2 smallint not null
     , k1 int not null
     , k2 smallint not null
     , l1 int not null
     , l2 int not null
     )
     IN $db.aper12
     AUDIT NONE
     DATA CAPTURE NONE
     CCSID      EBCDIC
     NOT VOLATILE ;
CREATE unique INDEX $creator.Iper12i1u
  ON $creator.tper12
   (i1)
  USING STOGROUP GSMS
  PRIQTY -1 SECQTY -1
  ERASE  NO
  FREEPAGE 0 PCTFREE 5
  GBPCACHE CHANGED
      cluster
  BUFFERPOOL BP1
  CLOSE YES
  COPY NO
  DEFER NO
  DEFINE YES ;
CREATE        INDEX $creator.Iper12i2d
  ON $creator.tper12
   (i1, i2)
  USING STOGROUP GSMS
  PRIQTY -1 SECQTY -1
  ERASE  NO
  FREEPAGE 0 PCTFREE 5
  GBPCACHE CHANGED
  not cluster
  BUFFERPOOL BP1
  CLOSE YES
  COPY NO
  DEFER NO
  DEFINE YES ;
CREATE unique INDEX $creator.Iper12j1u
  ON $creator.tper12
   (j1)
  USING STOGROUP GSMS
  PRIQTY -1 SECQTY -1
  ERASE  NO
  FREEPAGE 0 PCTFREE 5
  GBPCACHE CHANGED
  not cluster
  BUFFERPOOL BP1
  CLOSE YES
  COPY NO
  DEFER NO
  DEFINE YES ;
CREATE unique INDEX $creator.Iper12j2u
  ON $creator.tper12
   (j1, j2)
  USING STOGROUP GSMS
  PRIQTY -1 SECQTY -1
  ERASE  NO
  FREEPAGE 0 PCTFREE 5
  GBPCACHE CHANGED
  not cluster
  BUFFERPOOL BP1
  CLOSE YES
  COPY NO
  DEFER NO
  DEFINE YES ;
CREATE        INDEX $creator.Iper12k1d
  ON $creator.tper12
   (k1)
  USING STOGROUP GSMS
  PRIQTY -1 SECQTY -1
  ERASE  NO
  FREEPAGE 0 PCTFREE 5
  GBPCACHE CHANGED
  not cluster
  BUFFERPOOL BP1
  CLOSE YES
  COPY NO
  DEFER NO
  DEFINE YES ;
CREATE unique INDEX $creator.Iper12k2u
  ON $creator.tper12
   (k1, k2)
  USING STOGROUP GSMS
  PRIQTY -1 SECQTY -1
  ERASE  NO
  FREEPAGE 0 PCTFREE 5
  GBPCACHE CHANGED
  not cluster
  BUFFERPOOL BP1
  CLOSE YES
  COPY NO
  DEFER NO
  DEFINE YES ;
CREATE unique INDEX $creator.Iper12l1u
  ON $creator.tper12
   (l1)
  USING STOGROUP GSMS
  PRIQTY -1 SECQTY -1
  ERASE  NO
  FREEPAGE 0 PCTFREE 5
  GBPCACHE CHANGED
  not cluster
  BUFFERPOOL BP1
  CLOSE YES
  COPY NO
  DEFER NO
  DEFINE YES ;
CREATE        INDEX $creator.Iper12l2d
  ON $creator.tper12
   (l1, l2)
  USING STOGROUP GSMS
  PRIQTY -1 SECQTY -1
  ERASE  NO
  FREEPAGE 0 PCTFREE 5
  GBPCACHE CHANGED
  not cluster
  BUFFERPOOL BP1
  CLOSE YES
  COPY NO
  DEFER NO
  DEFINE YES ;
  commit;
Insert into $creator.tper12
     SELECT row_number () over(), mod(row_number () over(), 32000),
            row_number () over(), mod(row_number () over(), 32000),
            row_number () over(), mod(row_number () over(), 32000),
            row_number () over(), mod(row_number () over(), 32000)
         FROM sysibm.syscolumns
         fetch first 100000 rows only
;
commit;