zOs/TX/WK953DDL

  SET CURRENT SQLID='S100447';
  DROP   TABLESPACE $db.A953A;
  commit;
  CREATE TABLESPACE A953A
    IN $db
    USING STOGROUP GSMS
    PRIQTY -1 SECQTY -1
    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.TWK953A1
$@[
if $phase = 1 then  $@=[
     (cOne              char(11) FOR SBCS DATA NOT NULL,
      cTwo              char(2) FOR SBCS DATA NOT NULL,
      ADBTEMPCOL1       int,
      cThree            char(33) FOR SBCS DATA NOT NULL)
$] else if $phase = 2 then $@=[
     (cOne              char(11) FOR SBCS DATA NOT NULL,
      cTwo              char(2) FOR SBCS DATA NOT NULL,
      ADBTEMPCOL1       int,
      cThree            char(3) FOR SBCS DATA NOT NULL with default,
      cThreeRenamed     char(33) FOR SBCS DATA NOT NULL)
$] else if $phase = 3 then $@=[
     (cOneRenamed       char(11) FOR SBCS DATA NOT NULL,
      cTwo              char(2) FOR SBCS DATA NOT NULL,
      ADBTEMPCOL1       int,
      cThree            char(3) FOR SBCS DATA NOT NULL with default,
      cOne              char(1) FOR SBCS DATA NOT NULL)
$] else if $phase = 4 then $@=[
     (cOneRenamed       char(11) FOR SBCS DATA NOT NULL,
      cTwo              char(2) FOR SBCS DATA NOT NULL,
      ADBTEMPCOL1       int,
      cThree            char(3) FOR SBCS DATA NOT NULL with default,
      cNeu              char(1) FOR SBCS DATA NOT NULL)
$]
$]
    IN $db.A953A
    AUDIT NONE
    DATA CAPTURE NONE
    CCSID      EBCDIC
    NOT VOLATILE;
commit;