zOs/TX/WK967DDL

  set current sqlid = 'S100447';
  drop tablespace  $db.a967a;
  commit;
$@[
if $phase >= 1 then $@=[
  CREATE TABLESPACE A967A
    IN $db
    USING STOGROUP GSMS
    PRIQTY 12 SECQTY 7200
    FREEPAGE 10 PCTFREE 10
    GBPCACHE CHANGED
    TRACKMOD YES
    segsize 64
    LOCKSIZE ANY
    LOCKMAX SYSTEM
    CLOSE YES
    COMPRESS YES
    CCSID      EBCDIC
    DEFINE YES
    MAXROWS 255
;
  CREATE TABLE $creator.TWK967A1
     (WK967CHA             CHAR(10) NOT NULL
$@[
    if $phase = 2 then $@=[
     ,WK967CHB             CHAR(10) NOT NULL with default
$]
$]
     )
    IN $db.A967A
    AUDIT NONE
    DATA CAPTURE NONE
    CCSID      EBCDIC
    NOT VOLATILE
;
$@[
    if $phase = 2 then $@=[
 LABEL ON $creator.TWK967A1
     (WK967CHB is 'appended')
 ;
$]
$]
  CREATE INDEX $creator.IWK967A0
    ON $creator.TWK967A1
    (WK967CHA              desc
    )
    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
;
  CREATE INDEX $creator.IWK967A1
    ON $creator.TWK967A1
    (WK967CHA              ASC
$@[
    if $phase = 2 then $@=[
     ,WK967CHB             ASC
$]
$]
    )
    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
;
$@[
    if $phase = 1 then $@=[
  create view $creator.vWk967 (cha)
       as select wk967cha from $creator.tWk967a1;
$] else if $phase = 2 then $@=[
  create view $creator.vWk967 (cha, chb)
       as select wk967cha, wk967chb from $creator.tWk967a1;
$]
$]
  COMMIT;
$]
$]