zOs/TX/WK913DDL

------------$-[right(userid() sysvar(sysnode) date(s) time(), 60, '-')$]
-- testCase $dsn
-- env      $env      phase $phase
-- dbSys    $dbSys      db $db       creator $creator
------------------------------------------------------------------------
---||| begin ddl testcase $mbr env $env phase $phase
  SET CURRENT SQLID='S100447';
  drop   TABLESPACE $db.A913K;
  commit;
  CREATE TABLESPACE A913K
    IN $db
    USING STOGROUP GSMS
    PRIQTY -1 SECQTY -1
    FREEPAGE 0 PCTFREE 10
    GBPCACHE CHANGED
    TRACKMOD YES
    NUMPARTS 4
    BUFFERPOOL BP2
    LOCKSIZE ANY
    LOCKMAX SYSTEM
    CLOSE YES
    COMPRESS YES
    CCSID      EBCDIC
    DEFINE YES
    MAXROWS 255;
  COMMIT;
------------------------------------------------------------------------
  CREATE TABLE $creator.TWK913K1
     (WK913K001            CHAR(3) FOR SBCS DATA NOT NULL
     ,WK913K002            CHAR(4) FOR SBCS DATA NOT NULL
     ,WK913K003            CHAR(20) FOR SBCS DATA NOT NULL
     )
    IN $db.A913K
$@[
if $phase >= 2 then $@=[
     partition by (WK913K001)
     (PART 1 VALUES('100')
     ,PART 2 VALUES('200')
     ,PART 3 VALUES('300')
     ,PART 4 VALUES('400')
     )
$]
$]
    AUDIT NONE
    DATA CAPTURE NONE
    CCSID      EBCDIC
    NOT VOLATILE;
  COMMIT;
------------------------------------------------------------------------
  CREATE        INDEX $creator.IWK913K1
    ON $creator.TWK913K1
     (WK913K001             ASC
     ,WK913K002             ASC
     )
    USING STOGROUP GSMS
    PRIQTY -1 SECQTY -1
    FREEPAGE 0 PCTFREE 10
    GBPCACHE CHANGED
    CLUSTER
$@[
if $phase = 1 then $@=[
     (PART 1 VALUES('100')
     ,PART 2 VALUES('200')
     ,PART 3 VALUES('300')
     ,PART 4 VALUES('400')
     )
$] else $@=[
    partitioned
$]
$]
    BUFFERPOOL BP1
    CLOSE YES
    COPY NO
    DEFINE YES;
  COMMIT;
insert into $creator.TWK913K1 values('010', '010+', '010*****');
insert into $creator.TWK913K1 values('110', '110+', '110*****');
insert into $creator.TWK913K1 values('210', '210+', '210*****');
insert into $creator.TWK913K1 values('310', '310+', '310*****');
commit;
insert into $creator.TWK913K1 values('410', '410+', '410*****');
insert into $creator.TWK913K1 values('510', '510+', '510*****');

---||| end   ddl testcase $mbr env $env phase $phase