zOs/TX/WK906DDL

------------$-{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.a906a;
commit;
------------------------------------------------------------------------
CREATE TABLESPACE A906A
    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.TWK906A1
     (WK906CH20            CHAR(20) FOR SBCS DATA not null with default
$@[
if $phase >= 2 then $@=[
     ,WK906CH5             CHAR(4) FOR SBCS DATA not null with default
$] if $phase >= 3 then $@=[
     ,WK906CH2             CHAR(2) FOR SBCS DATA not null with default
$] if $phase >= 4 then $@=[
     ,WK906TST             TIMESTAMP not null with default
$] if $phase >= 5 then $@=[
     ,WK906CH7             CHAR(7) FOR SBCS DATA not null with default
$]
$]
     )
    IN $db.A906A
    AUDIT NONE
    DATA CAPTURE NONE
    CCSID      EBCDIC
    NOT VOLATILE ;
LABEL ON TABLE $creator.TWK906A1 IS 'Modellversion';
LABEL ON $creator.TWK906A1
      (WK906CH20 is 'ch20 char(20)'
 $@[
 if $phase >= 2 then $@=[
      ,WK906CH5  is 'ch5  char(5)'
 $] if $phase >= 3 then $@=[
      ,WK906CH2  is 'ch2  char(2)'
 $] if $phase >= 4 then $@=[
      ,WK906TST  is 'tst timestamp'
 $] if $phase >= 5 then $@=[
      ,WK906CH7  is 'ch7 char(7)'
 $]
 $]
      )
;
commit
---||| end   ddl testcase $mbr env $env phase $phase