zOs/TX/WK938DDL

------------$-{right(userid() sysvar(sysnode) date(s) time(), 60, '-')}
-- testCase $dsn
-- env      $env      phase $phase
-- subsys   $subsys     db $db       creator $creator
------------------------------------------------------------------------
---||| begin ddl testcase $mbr env $env phase $phase
SET CURRENT SQLID='S100447';
drop tablespace $db.A938A;
drop tablespace $db.A938B;
commit;
------------------------------------------------------------------------
CREATE TABLESPACE A938A
  IN $db
  USING STOGROUP GSMS
  PRIQTY 12 SECQTY 7200
  FREEPAGE 0 PCTFREE 0
  GBPCACHE CHANGED
  TRACKMOD YES
  BUFFERPOOL BP2
  SEGSIZE 64
  LOCKSIZE ANY
  LOCKMAX SYSTEM
  CLOSE YES
  COMPRESS YES
  CCSID      EBCDIC
  DEFINE YES
  MAXROWS 255;
CREATE TABLESPACE A938B
  IN $db
  USING STOGROUP GSMS
  PRIQTY 12 SECQTY 7200
  FREEPAGE 0 PCTFREE 0
  GBPCACHE CHANGED
  TRACKMOD YES
  BUFFERPOOL BP32K
  SEGSIZE 64
  LOCKSIZE ANY
  LOCKMAX SYSTEM
  CLOSE YES
  COMPRESS YES
  CCSID      EBCDIC
  DEFINE YES
  MAXROWS 255;
------------------------------------------------------------------------
create TABLE $creator.CTINSTRDETAILS  like VDPS2.CTINSTRDETAILS
    in $db.A938A
;
create TABLE $creator.VTINSTRFLATDATA like VDPS2.VTINSTRFLATDATA
    in $db.A938B
;
commit;
$@[
    if $phase > 1 then $@=[
alter  TABLE $creator.CTINSTRDETAILS
     add testOnly int not null with default -1;
alter  TABLE $creator.VTINSTRFLATDATA
     add testOnly int not null with default -1;
commit;
$]
$]