zOs/TX/WK988DDL

  set current sqlid = 'S100447';
  drop   TABLESPACE $db.a988a;
  commit;
$@[
if $phase >= 1 then $@=[
  CREATE TABLESPACE a988a
    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.TWK988a1
     (WK988i               SMALLINT NOT NULL,
      WK988d               date    NOT NULL,
      WK988t               timestamp NOT NULL
     )
     in $db.a988a
    AUDIT NONE
    DATA CAPTURE NONE
    CCSID      EBCDIC
    NOT VOLATILE
    APPEND NO  ;
 CREATE unique INDEX $creator.IWK988i1
   ON $creator.TWK988a1
    (wk988t)
   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;
  commit;
  insert into $creator.TWK988a1
       values (1, '01.04.1956', '1956-04-01-06.12.34.5678');
  insert into $creator.TWK988a1
       values (1, current date, current timestamp);
  insert into $creator.TWK988a1
       values (1, current date, current timestamp);
  commit;
  $]
  $]