zOs/TX/WK946DDL

  SET CURRENT SQLID  = 'S100447';
  SET CURRENT SCHEMA = '$creator';
  SET CURRENT PATH   = '$creator';

  drop   TABLESPACE $db.A946A ;
  drop   TABLESPACE $db.A946H ;
  commit;
$@[
if $phase > 0 then $@=[
  CREATE TABLESPACE A946A
    IN $db
    USING STOGROUP GSMS
    SEGSIZE 4
    BUFFERPOOL BP2
    LOCKSIZE ANY
    COMPRESS YES;
  CREATE TABLE $creator.TWK946A1
     (WK94601              INTEGER NOT NULL GENERATED ALWAYS
        AS IDENTITY,
      WK94610              VARCHAR(256) NOT NULL,
      WK94620              INTEGER NOT NULL,
      WK94621              INTEGER NOT NULL,
      WK94630              DECIMAL(19, 0) NOT NULL,
      WK94611              VARCHAR(256)
     ,WK94640              VARCHAR(256)
$*(  ,CONSTRAINT WK94601
      PRIMARY KEY (WK94601),
      CONSTRAINT WK94610
      UNIQUE      (WK94610,
                   WK94620,
                   WK94621)
$*)  )
    IN $db.A946A;
$*(
  CREATE UNIQUE INDEX $creator.IWK94601
    ON $creator.TWK946A1
     (WK94601               ASC)
    USING STOGROUP GSMS
    BUFFERPOOL BP1;
  CREATE UNIQUE INDEX $creator.IWK94602
    ON $creator.TWK946A1
     (WK94610               ASC,
      WK94620               ASC,
      WK94621               ASC)
    USING STOGROUP GSMS
    BUFFERPOOL BP1;
$*)
  CREATE TABLESPACE A946H
    IN $db
    USING STOGROUP GSMS
    SEGSIZE 4
    BUFFERPOOL BP2
    LOCKSIZE ANY
    COMPRESS YES;
  CREATE TABLE $creator.TWK946H1
     (WK946991             TIMESTAMP NOT NULL WITH DEFAULT,
      WK946992             CHAR(10) NOT NULL WITH DEFAULT SESSION_USER,
      WK946993             CHAR(10) NOT NULL
        WITH DEFAULT CURRENT SQLID ,
      WK946994             CHAR(1) NOT NULL WITH DEFAULT 'U',
      WK94601              INTEGER NOT NULL,
      WK94610              VARCHAR(256) NOT NULL,
      WK94620              INTEGER NOT NULL,
      WK94621              INTEGER NOT NULL,
      WK94630              DECIMAL(19, 0) NOT NULL,
      WK94611              VARCHAR(256)
     ,WK94640              VARCHAR(256)
$*(
     ,CONSTRAINT WK946991
      PRIMARY KEY (WK946991,
                   WK94601),
      CONSTRAINT WK9469911
      UNIQUE      (WK946991,
                   WK94610,
                   WK94620,
                   WK94621)
$*)
     )
    IN $db.A946H;
$*(
  CREATE UNIQUE INDEX $creator.IWK946H1
    ON $creator.TWK946H1
     (WK946991              ASC,
      WK94601               ASC)
    USING STOGROUP GSMS
    BUFFERPOOL BP1;
  CREATE UNIQUE INDEX $creator.IWK946H2
    ON $creator.TWK946H1
     (WK946991              ASC,
      WK94610               ASC,
      WK94620               ASC,
      WK94621               ASC)
    USING STOGROUP GSMS
    BUFFERPOOL BP1;
  CREATE VIEW $creator.VKD_RS_ENABLED_VIEW AS
    SELECT RA.WK94601 AS RA_ID, RA.WK94610 AS RA_NAME,
           RA.WK94620 AS RA_MAJVERS, RA.WK94621 AS RA_MINVERS,
           RS.KD10101 AS RS_ID, RS.KD10110 AS RS_NAME,
           RS.KD10120 AS RS_MAJVERS, RS.KD10121 AS RS_MINVERS
      FROM TWK946A1 RA,
           TKD101A1 RS,
           TKD103A1 P
      WHERE RS.KD10102 = RA.WK94601
        AND RS.KD10101 = P.KD10302
        AND P.KD10310 = 'ruleset.status'
        AND P.KD10341 = 'enabled' ;
  CREATE VIEW $creator.VKD_RULEAPPS AS
    SELECT WK94601 AS ID, WK94610 AS NAME, WK94620 AS MAJOR_VERSION,
           WK94621 AS MINOR_VERSION, WK94630 AS CREATION_DATE,
           WK94611 AS DISPLAY_NAME, WK94640 AS DESCRIPTION
      FROM TWK946A1 ;
  CREATE VIEW $creator.VKD_RULEAPPS_HIST AS
    SELECT WK946991 AS LOGTS, WK946992 AS LOGUSER,
           WK946993 AS LOGSQLID, WK946994 AS LOGTYPE, WK94601 AS ID,
           WK94610 AS NAME, WK94620 AS MAJOR_VERSION,
           WK94621 AS MINOR_VERSION, WK94630 AS CREATION_DATE,
           WK94611 AS DISPLAY_NAME, WK94640 AS DESCRIPTION
      FROM TWK946H1 ;
$*)
  CREATE TRIGGER $-[if($triCre >= 1, $creator'.', '')$]WK946HAD
    AFTER DELETE ON $-[if($triCre >= 2, $creator'.', '')$]TWK946A1
    REFERENCING OLD_TABLE AS OWK946
    FOR EACH ROW MODE DB2SQL
      INSERT INTO $-[if($triCre >= 3, $creator'.', '')$]TWK946H1
        (WK946991, WK946992, WK946993, WK946994, WK94601, WK94610,
        WK94620, WK94621, WK94630, WK94611, WK94640)
        SELECT CURRENT TIMESTAMP, USER, CURRENT SQLID, 'D', WK94601,
               WK94610, WK94620, WK94621, WK94630, WK94611, WK94640
          FROM OWK946 ;
  CREATE TRIGGER $-[if($triCre >= 1, $creator'.', '')$]WK946HAU
    AFTER UPDATE ON $-[if($triCre >= 2, $creator'.', '')$]TWK946A1
    REFERENCING OLD_TABLE AS OWK946
    FOR EACH ROW MODE DB2SQL
      INSERT INTO $-[if($triCre >= 3, $creator'.', '')$]TWK946H1
        (WK946991, WK946992, WK946993, WK946994, WK94601, WK94610,
        WK94620, WK94621, WK94630, WK94611, WK94640)
        SELECT CURRENT TIMESTAMP, USER, CURRENT SQLID, 'U', WK94601,
               WK94610, WK94620, WK94621, WK94630, WK94611, WK94640
          FROM OWK946 ;
  COMMIT;
$]
$]