zOs/TX/WK969DDL

  set current sqlid = 'S100447';
  set current schema = '$creator';
  drop view $creator.vwk969;
  drop tablespace $db.a969a;
  commit;
$@[
if $phase >= 1 then $@=[
   CREATE TABLESPACE A969A
     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.TWK969A1
      (WK969CHA             CHAR(10) NOT NULL
      )
     IN $db.A969A
     AUDIT NONE
     DATA CAPTURE NONE
     CCSID      EBCDIC
     NOT VOLATILE
;
  create view $creator.vwk969
      as select '$creator.vwk969' who , t.*
      from twk969a1 t;
--set current sqlid  = '${creator}A';
  set current schema = '${creator}A';
  create synonym             vwk969 for $creator.vwk969;
  COMMIT;
$]
$]