zOs/TX/WK943DDL

------------$-{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.A943A;
drop tablespace $db.A943B;
commit;
  CREATE TABLESPACE A943A
    IN $db
    USING STOGROUP GSMS
    PRIQTY -1     SECQTY -1
    FREEPAGE 5 PCTFREE 10
    SEGSIZE 64
    BUFFERPOOL BP2
    LOCKSIZE ANY
    CLOSE NO
    COMPRESS YES;
commit;
  CREATE TABLESPACE A943B
    IN $db
    USING STOGROUP GSMS
    PRIQTY -1     SECQTY -1
    FREEPAGE 5 PCTFREE 10
    NUMPARTS 1
    BUFFERPOOL BP2
    LOCKSIZE ANY
    CLOSE NO
    COMPRESS YES;
  CREATE TABLE $creator.TWK943A
     (
      key                  CHAR(10) NOT NULL WITH DEFAULT
     ,C2                   CHAR(2) NOT NULL WITH DEFAULT
$@[
if $phase >= 2 then $@=[
     ,C3                   CHAR(3) NOT NULL WITH DEFAULT
$]
$]
     )
    IN $db.A943A
;
  CREATE TABLE $creator.TWK943B
    (
$@[
if $phase <= 1 then $@=[
      key                  CHAR(10) NOT NULL WITH DEFAULT,
      C2                   CHAR(2) NOT NULL WITH DEFAULT,
      C3                   CHAR(3) NOT NULL WITH DEFAULT
$] else $@=[
      C3                   CHAR(2) NOT NULL WITH DEFAULT,
      C2                   CHAR(1) NOT NULL WITH DEFAULT,
      key                  CHAR(9) NOT NULL WITH DEFAULT
$]
$]
     )
    IN $db.A943B
     partition by (key) (part 1 values('99'))
;
commit;