zOs/TX/WK908DDL

------------$-{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.a908a;
commit;
------------------------------------------------------------------------
CREATE TABLESPACE A908A
    IN $db
    USING STOGROUP GSMS
    PRIQTY -1 SECQTY -1
    ERASE  NO
    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
;  ---------------------------------------------------------------------
  CREATE TABLE $creator.TWK908A1
     (WK908CH20            CHAR(20) FOR SBCS DATA not null with default
     ,WK908CH5             CHAR(4) FOR SBCS DATA not null with default
     ,WK908CH2             CHAR(2) FOR SBCS DATA not null with default
     ,WK908TST             TIMESTAMP not null with default
     ,WK908CH7             CHAR(7) FOR SBCS DATA not null with default
     )
    IN $db.A908A
    AUDIT NONE
    DATA CAPTURE NONE
    CCSID      EBCDIC
    NOT VOLATILE ;
commit
;  ---------------------------------------------------------------------
CREATE INDEX $creator.IWK908A0
  ON $creator.TWK908A1
   (WK908CH20             ASC)
  USING STOGROUP GSMS
  PRIQTY -1 SECQTY -1
  ERASE  NO
  FREEPAGE 0 PCTFREE 10
  GBPCACHE CHANGED
$@[
if $phase <= 1 then $@=[
  CLUSTER
$] else $@=[
  not CLUSTER
$]
$]
  BUFFERPOOL BP1
  CLOSE YES
  COPY NO
  DEFINE YES
  PIECESIZE 2 G
;
CREATE INDEX $creator.IWK908A1
  ON $creator.TWK908A1
   (WK908CH5              ASC)
  USING STOGROUP GSMS
  PRIQTY -1 SECQTY -1
  ERASE  NO
  FREEPAGE 0 PCTFREE 10
  GBPCACHE CHANGED
$@[
if $phase >  1 then $@=[
  CLUSTER
$] else $@=[
  not CLUSTER
$]
$]
  BUFFERPOOL BP1
  CLOSE YES
  COPY NO
  DEFINE YES
  PIECESIZE 2 G
;
commit
---||| end   ddl testcase $mbr env $env phase $phase