zOs/TX/WK994DDL

  set current sqlid = 'S100447';
  drop   TABLESPACE $db.a994A;
  commit;
$@[
if $phase >= 1 then $@=[
  CREATE TABLESPACE a994A
    IN $db
    USING STOGROUP GSMS
    PRIQTY -1 SECQTY -1
    FREEPAGE 10 PCTFREE 5
    GBPCACHE CHANGED
    TRACKMOD YES
    LOGGED
    BUFFERPOOL BP2
    SEGSIZE 64
    LOCKSIZE ANY
    LOCKMAX SYSTEM
    CLOSE $-[if($phase=1, yes, no)$]
    COMPRESS YES
    CCSID      EBCDIC
    DEFINE YES
    MAXROWS 255;
  CREATE TABLE $creator.TWK994a1
     (parIdVeryVeryVeryVeryVeryLong  int not null with default
     ,nameVeryVeryVeryVeryVeryLong   varchar(30) not null with default
     ,tstVeryVeryVeryVeryVeryLong   timestaMP   not null with default
$@[
if $phase >= 2 then $@=[
     , int1                   SMALLINT NOT NULL WITH DEFAULT
     , tst1                   TIMESTAMP (6) NOT NULL
           WITH DEFAULT '0001-01-01-00.00.00.000000'
     , tst2                   TIMESTAMP (6) NOT NULL
           WITH DEFAULT '9999-12-31-23.59.59.999999'
$]
$]
   , primary key(parIdVeryVeryVeryVeryVeryLong
                ,nameVeryVeryVeryVeryVeryLong
                ,tstVeryVeryVeryVeryVeryLong
                $-[if($phase=1, , ', tst1')$])
     )
    IN $db.a994A
    AUDIT NONE
    DATA CAPTURE NONE
    CCSID      EBCDIC
    NOT VOLATILE
    APPEND NO  ;
$@[
if $phase >= 2 then $@=[
   LABEL ON $creator.twk994a1
    (int1     IS 'VALID TO',
     tst1     IS 'VALID FROM',
     tst2     IS 'ROW STATUS');
$]
$]
CREATE unique INDEX $creator.IWK994I1
  ON $creator.TWK994a1
   (parIdVeryVeryVeryVeryVeryLong
                ,nameVeryVeryVeryVeryVeryLong
                ,tstVeryVeryVeryVeryVeryLong
                $-[if($phase=1, , ', tst1')$])
  USING STOGROUP GSMS
  PRIQTY -1 SECQTY -1
  ERASE  NO
  FREEPAGE 5 PCTFREE 10
  GBPCACHE CHANGED
  NOT CLUSTER
  COMPRESS NO
  BUFFERPOOL BP1
  CLOSE YES
  COPY NO
  DEFER NO
  DEFINE YES;
$*(
  insert into $creator.TWK994a1 values (1, 'walter') ;
  insert into $creator.TWK994Ahi values (1, 'gregor') ;
  insert into $creator.TWK994Ahi values (1, 'david') ;
  insert into $creator.TWK994Ahi values (1, 'florian') ;
  insert into $creator.TWK994a1 values (2, 'eveline') ;
  insert into $creator.TWK994Ahi values (2, 'stefan') ;
  insert into $creator.TWK994Ahi values (2, 'jerome') ;
$*)
    commit;
    $]
$]