zOs/TX/WK924DDL

------------$-{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
$=cr2=$creator
SET CURRENT SQLID='S100447';
drop tablespace $db.a924a;
drop table     $creator.TWK924;
commit;
------------------------------------------------------------------------
CREATE TABLESPACE A924A
    IN $db
    USING STOGROUP GSMS
    PRIQTY -1 SECQTY -1
    ERASE  NO
    FREEPAGE 0 PCTFREE 10
    GBPCACHE CHANGED
    TRACKMOD YES
    SEGSIZE  64
    BUFFERPOOL BP32K
    LOCKMAX SYSTEM
    CLOSE YES
    COMPRESS YES
    CCSID      EBCDIC
    DEFINE YES
    locksize row
    MAXROWS 255
;
commit;
  CREATE TABLE $creator.TWK924
     (key                  int     NOT NULL,
      text                 CHAR(50) NOT NULL
     ) in $db.A924A;
--------------------------------------------------------------
  CREATE UNIQUE INDEX $creator.IWK9240
    ON $creator.TWK924
     (key                   ASC)
    USING STOGROUP GSMS
    PRIQTY -1    SECQTY -1
    ERASE  NO
    FREEPAGE 0 PCTFREE 10
    GBPCACHE CHANGED
    NOT CLUSTER
    BUFFERPOOL BP1
    CLOSE YES
    COPY NO
    DEFER NO
    DEFINE YES
    PIECESIZE 2 G;
  COMMIT;
commit;
  insert into $creator.TWK924 values
      (1, char(current timestamp) || ' initial eins');
  insert into $creator.TWK924 values
      (2, char(current timestamp) || ' initial zwei');
  insert into $creator.TWK924 values
      (3, char(current timestamp) || ' initial drei');
  commit;
---||| end   ddl testcase $mbr env $env phase $phase