zOs/TX/WK987DDL

  set current sqlid = 'S100447';
  drop   TABLESPACE $db.a987a;
  commit;
$@[
if $phase >= 1 then $@=[
  CREATE TABLESPACE a987a
    IN $db
    USING STOGROUP GSMS
    PRIQTY -1 SECQTY -1
    FREEPAGE 10 PCTFREE 5
    GBPCACHE CHANGED
    TRACKMOD YES
    LOGGED
    NUMPARTS 2
    BUFFERPOOL BP2
    LOCKSIZE ANY
    LOCKMAX SYSTEM
    CLOSE $-[if($phase=3, YES, NO)$]
    COMPRESS YES
    CCSID      EBCDIC
    DEFINE YES
    MAXROWS 255;
  CREATE TABLE $creator.TWK987a1
     (part   SMALLINT NOT NULL
     ,text   varCHAR(40) FOR SBCS DATA NOT NULL
     )
    IN $db.a987a
$@[ if $phase = 2 then $@=[
    PARTITION BY (part asc)
       ( PART 1   VALUES(1)
       , PART 2   VALUES(2)
      )
$] $]
    AUDIT NONE
    DATA CAPTURE NONE
    CCSID      EBCDIC
    NOT VOLATILE
    APPEND NO  ;
    commit;

    CREATE INDEX $creator.IWK987a0
      ON $creator.TWK987a1
       (part asc)
      USING STOGROUP GSMS
      PRIQTY -1 SECQTY -1
      ERASE  NO
      FREEPAGE 10 PCTFREE 5
      GBPCACHE CHANGED
      CLUSTER
$@[ if $phase = 2 then $@=[
      partitioned
 $] else $@=[

       ( PART 1   VALUES(1)
       , PART 2   VALUES(2)
      )
$] $]
      COMPRESS NO
      BUFFERPOOL BP1
      CLOSE YES
      COPY NO
      DEFER NO
      DEFINE YES
      ;
commit
;
$]
if $phase  >= 3 then $@=[
    drop index $creator.IWK987a0 ;
    alter table $creator.TWK987a1 alter partition 2 ending (2);
    commit;
$]
$]