zOs/TX/WK975DDL

  set current sqlid = 'S100447';
  set current schema = '$creator';
  drop tablespace $db.awk975a;
  commit;
$@[
if $phase >= 1 then $@=[
   CREATE TABLESPACE awk975A
     IN $db
     USING STOGROUP GSMS
     PRIQTY 12 SECQTY 7200
     FREEPAGE 10 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.Tqz91wk975A1
      (wk975CHA             CHAR(20) NOT NULL
      ,wk975CHB             CHAR(10) NOT NULL
      ,wk975CHC             CHAR(10) NOT NULL
      )
     IN $db.awk975A
     AUDIT NONE
     DATA CAPTURE NONE
     CCSID      EBCDIC
     NOT VOLATILE
;

  CREATE unique INDEX $creator.Iqz91wk975A$-[min(2,$phase)$]
    ON $creator.Tqz91wk975A1
    (wk975CHA              asc
    )
    USING STOGROUP GSMS
    PRIQTY 12 SECQTY 7200
    ERASE  NO
    FREEPAGE 10 PCTFREE 10
    GBPCACHE CHANGED
    $-[if($phase <=2,CLUSTER, NOT CLUSTER)$]
    BUFFERPOOL BP1
    CLOSE YES
    COPY NO
    DEFER NO
    DEFINE YES
    PIECESIZE 2 G
;
   alter  TABLE $creator.Tqz91wk975A1
       add primary key (wk975cha)
;
$@[
if $phase >= 3 then $@=[
  CREATE INDEX $creator.Iqz91wk975AClu
    ON $creator.Tqz91wk975A1
    (wk975CHB              asc
    )
    USING STOGROUP GSMS
    PRIQTY 12 SECQTY 7200
    ERASE  NO
    FREEPAGE 10 PCTFREE 10
    GBPCACHE CHANGED
    cluster
    BUFFERPOOL BP1
    CLOSE YES
    COPY NO
    DEFER NO
    DEFINE YES
    PIECESIZE 2 G
;
$]
if $phase >= 4 then $@=[
  CREATE INDEX $creator.Iqz91wk975AC
    ON $creator.Tqz91wk975A1
    (wk975CHC, wk975chb
    )
    USING STOGROUP GSMS
    PRIQTY 12 SECQTY 7200
    ERASE  NO
    FREEPAGE 10 PCTFREE 10
    GBPCACHE CHANGED
    not cluster
    BUFFERPOOL BP1
    CLOSE YES
    COPY NO
    DEFER NO
    DEFINE YES
    PIECESIZE 2 G
;
$]
$]
commit
;
$]
if $phase >= 1 then $@=[
   insert into $creator.Tqz91wk975A1
       select left(name   || 'abcdefghijklm', 10)
              || ' ' || char(row_number () over ()),
              substr(name || 'abcdefghijklm', 2, 10),
              substr(name || 'abcdefghijklm', 3, 10)
       from sysibm.syscolumns
       fetch first 1000 rows only
   ;
   commit
   ;
$]
$]