zOs/TX/TT01DDL

------------$-{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.ATT01;
  commit;
$@[
  if $phase > 0 then $@=[
  CREATE TABLESPACE ATT01
    IN $db
    USING STOGROUP GSMS
    PRIQTY -1 SECQTY -1
    FREEPAGE 0 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;
------------------------------------------------------------------------
  CREATE TABLE $creator.TWKTT01A1
     (i                   int      NOT NULL
     ,USR                 CHAR(20) NOT NULL WITH DEFAULT USER
 --                                GENErated always
     ,SQLD                CHAR(20) NOT NULL WITH DEFAULT current sqlid
 --                                GENErated always
     ,tst                  timestamp  not null with default
  --                               GENErated always
     )
    IN $db.ATT01
    CCSID      EBCDIC
    NOT VOLATILE;
  insert into $creator.TWKTT01A1 (i) values (1);
  insert into $creator.TWKTT01A1 (i) values (2);
  COMMIT;
$]
$]
---||| end   ddl testcase $mbr env $env phase $phase