zOs/TX/WK944DDL

------------$-{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.A944A;
  COMMIT;
  CREATE TABLESPACE A944A
    IN $db
    USING STOGROUP GSMS
    FREEPAGE 0 PCTFREE 10
    DSSIZE 16 G
    NUMPARTS 11
    BUFFERPOOL BP2
    LOCKSIZE ANY
    COMPRESS YES;
  CREATE TABLE $creator.TWK944A1
     (WK944000             CHAR(1) NOT NULL,
      WK94401V             CHAR(1) NOT NULL,
      WK94401G             CHAR(3) NOT NULL,
      WK94401M             CHAR(8) NOT NULL,
      WK94401D             CHAR(20) NOT NULL,
      WK944002             CHAR(6) NOT NULL,
      WK944003             DATE NOT NULL,
      WK944004             DATE NOT NULL,
      WK944005             INTEGER NOT NULL,
      WK944006             TIMESTAMP NOT NULL,
      WK944008             TIMESTAMP NOT NULL,
      WK944010             CHAR(7) NOT NULL,
      WK944011             DATE NOT NULL,
      WK944012             DATE NOT NULL,
      WK944013             CHAR(1) NOT NULL,
      WK944014             CHAR(20) NOT NULL,
      WK944018             CHAR(76) NOT NULL,
      WK944019             CHAR(7) NOT NULL,
      WK944020             CHAR(10) NOT NULL,
      WK944021             CHAR(10) NOT NULL,
      CONSTRAINT WK944000
      PRIMARY KEY (WK944000,
                   WK94401V,
                   WK94401G,
                   WK94401M,
                   WK94401D,
                   WK944002,
                   WK944003,
                   WK944004,
                   WK944005))
    IN $db.A944A
    PARTITION BY (WK944000 ASC)
     (PART 1 VALUES('A'),
      PART 2 VALUES('0'),
      PART 3 VALUES('1'),
      PART 4 VALUES('2'),
      PART 5 VALUES('3'),
      PART 6 VALUES('4'),
      PART 7 VALUES('5'),
      PART 8 VALUES('6'),
      PART 9 VALUES('7'),
      PART 10 VALUES('8'),
      PART 11 VALUES('9'));
  LABEL ON TABLE $creator.TWK944A1 IS 'copy table TWK944A1';
  LABEL ON $creator.TWK944A1
   (WK944021 IS 'reserve',
    WK944020 IS 'reserve',
    WK944019 IS 'PID Entry',
    WK944018 IS 'free text',
    WK944014 IS 'CIF No',
    WK944013 IS 'Status',
    WK944012 IS 'Calculation valid to',
    WK944011 IS 'Calculation valid from',
    WK944010 IS 'PID Inactivation',
    WK944008 IS 'TS Inactivation',
    WK944006 IS 'TS Entry',
    WK944005 IS 'KEY running No',
    WK944004 IS 'KEY Agreement valid to',
    WK944003 IS 'KEY Agreement valid from',
    WK944002 IS 'KEY Search Key',
    WK94401D IS 'KEY SafekeepingAccount No',
    WK94401M IS 'KEY model type',
    WK94401G IS 'KEY fee type',
    WK94401V IS 'KEY contract type',
    WK944000 IS 'KEY part Key');
  CREATE UNIQUE INDEX $creator.IWK944B0
    ON $creator.TWK944A1
     (WK944000              ASC,
      WK94401V              ASC,
      WK94401G              ASC,
      WK94401M              ASC,
      WK94401D              ASC,
      WK944002              ASC,
      WK944003              ASC,
      WK944004              ASC,
      WK944005              ASC)
    USING STOGROUP GSMS
    FREEPAGE 10 PCTFREE 10
    CLUSTER
    BUFFERPOOL BP1;
  CREATE INDEX $creator.IWK944B1
    ON $creator.TWK944A1
     (WK944014              ASC)
    USING STOGROUP GSMS
    PRIQTY 12 SECQTY 7200
    FREEPAGE 10 PCTFREE 10
    BUFFERPOOL BP1;
$@[
if $phase >= 2 then  $@=[
  CREATE INDEX $creator.IWK944B2
    ON $creator.TWK944A1
     (WK94401D              ASC,
      WK944002              ASC,
      WK944003              ASC,
      WK944004              ASC,
      WK944005              ASC)
    USING STOGROUP GSMS
    FREEPAGE 10 PCTFREE 10
    BUFFERPOOL BP1;
$]
$]
  SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","$creator" ;
  CREATE VIEW $creator.VWK944A0(PARTITIONING_KEY, CONTRACT_TYPE,
      FEE_TYPE, MODEL_TYPE, SAC_NO, SEARCHKEY, VALID_FROM, VALID_TO,
      RUNNING_NO, TS_CREATION, TS_INACTIVATION, PID_INACTIVATION,
      CALCULATION_FROM, CALCULATION_TO, STATUS, CIF_NO, TEXT,
      PID_CREATION, RESERVE_1, RESERVE_2) AS
    SELECT ALL WK944000, WK94401V, WK94401G, WK94401M, WK94401D,
           WK944002, WK944003, WK944004, WK944005, WK944006, WK944008,
           WK944010, WK944011, WK944012, WK944013, WK944014, WK944018,
           WK944019, WK944020, WK944021
      FROM $creator.TWK944A1 ;
  CREATE VIEW $creator.VWK944A1(WK944000, WK94401V, WK94401G, WK94401M,
      WK94401D, WK944002, WK944003, WK944004, WK944005, WK944006,
      WK944008, WK944010, WK944011, WK944012, WK944013, WK944014,
      WK944018, WK944019, WK944020, WK944021) AS
    SELECT ALL WK944000, WK94401V, WK94401G, WK94401M, WK94401D,
           WK944002, WK944003, WK944004, WK944005, WK944006, WK944008,
           WK944010, WK944011, WK944012, WK944013, WK944014, WK944018,
           WK944019, WK944020, WK944021
      FROM $creator.TWK944A1 ;
  COMMIT;
---||| end   ddl testcase $mbr env $env phase $phase