zOs/TX/WK990DDL

  set current sqlid = 'S100447';
  drop   TABLESPACE $db.a990a;
  commit;
$@[
if $phase >= 1 then $@=[
  CREATE TABLESPACE a990a
    IN $db
    USING STOGROUP GSMS
    PRIQTY -1 SECQTY -1
    FREEPAGE 10 PCTFREE 5
    GBPCACHE CHANGED
    TRACKMOD YES
    LOGGED
    SEGSIZE 64
    BUFFERPOOL BP2
    LOCKSIZE ANY
    LOCKMAX SYSTEM
    CLOSE YES
    COMPRESS YES
    CCSID      EBCDIC
    DEFINE YES
    MAXROWS 255;
  CREATE TABLE $creator.TWK990a1
     (x1     SMALLINT NOT NULL
$@[
if $phase <= 1 then $@=[
     ,f2     date
$] else$@=[
     ,f2     integer
$]
$]
     )
    IN $db.a990a
    AUDIT NONE
    DATA CAPTURE NONE
    CCSID      EBCDIC
    NOT VOLATILE
    APPEND NO  ;
    commit;
$@[
if $phase <= 1 then $@=[
insert into $creator.twk990a1      values (1, current date);
insert into $creator.twk990a1      values (2, '01.04.1956' );
$] else$@=[
insert into $creator.twk990a1      values (1, 111);
insert into $creator.twk990a1      values (2, 222);
$]
$]
commit
;
$]
$]