zOs/TX/WK965DDL

------------$-{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.a965A;
  commit;
$@[
if $phase >= 1 then $@=[
  CREATE TABLESPACE A965A
    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;
--
  COMMIT;
--
------------------------------------------------------------------------
--    Table=$creator.Twk965A1 In $db.A965A
------------------------------------------------------------------------
--
  CREATE TABLE $creator.Twk965A1
     (Wk965CH$phase        char(10) not null
     , constraint ch  check (wk965ch$phase like 'ch%')
     ,wk965chb             char(10) NOT NULL
     ,wk965Inc             int      NOT NULL
     )
    IN $db.A965A
    AUDIT NONE
    DATA CAPTURE NONE
    CCSID      EBCDIC
    NOT VOLATILE
;
insert into $creator.twk965a1 values('chA$phase', 'a', $phase);
insert into $creator.twk965a1 values('chB$phase', 'b', $phase);
insert into $creator.twk965a1 values('chC$phase', 'c', $phase);
commit;
$]
$]