zOs/JCL/KDDDL
SET CURRENT SQLID = 'S100447';
CREATE DATABASE kd03$$$
BUFFERPOOL BP2
INDEXBP BP1
STOGROUP "GSMS "
CCSID EBCDIC;
CREATE TABLESPACE A301A
IN kd03$$$
USING STOGROUP "GSMS "
PRIQTY -1
SECQTY -1
ERASE NO
BUFFERPOOL BP2
CLOSE YES
LOCKMAX SYSTEM
SEGSIZE 64
FREEPAGE 0
PCTFREE 5
GBPCACHE CHANGED
DEFINE YES
LOGGED
TRACKMOD YES
COMPRESS YES
LOCKSIZE ANY
MAXROWS 255
CCSID EBCDIC;
CREATE TABLE oa1$$$.TKD301A1
(ID INTEGER
NOT NULL
GENERATED ALWAYS AS IDENTITY ( START WITH 1
, INCREMENT BY 1
, MINVALUE 1
, MAXVALUE 2147483647
, CACHE 20
, NOCYCLE
, NOORDER )
,"NAME" VARCHAR(256) FOR SBCS DATA
NOT NULL
,MAJOR_VERSION INTEGER
NOT NULL
,MINOR_VERSION INTEGER
NOT NULL
,CREATION_DATE DECIMAL(19, 0)
NOT NULL
,DISPLAY_NAME VARCHAR(256) FOR SBCS DATA
WITH DEFAULT NULL
,DESCRIPTION VARCHAR(256) FOR SBCS DATA
WITH DEFAULT NULL
,CONSTRAINT CKD301A0 PRIMARY KEY
(ID
)
,CONSTRAINT CKD301A1 UNIQUE
("NAME"
,MAJOR_VERSION
,MINOR_VERSION
)
)
IN kd03$$$.A301A
APPEND NO
WITH RESTRICT ON DROP
NOT VOLATILE CARDINALITY
DATA CAPTURE CHANGES
AUDIT NONE
CCSID EBCDIC;
CREATE UNIQUE INDEX oa1$$$.IKD301A0
ON oa1$$$.TKD301A1
(ID ASC
)
NOT CLUSTER
DEFINE YES
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
DEFER NO
COPY NO
USING STOGROUP "GSMS "
PRIQTY -1
SECQTY -1
ERASE NO
FREEPAGE 0
PCTFREE 10
GBPCACHE CHANGED
PIECESIZE 2097152K;
CREATE UNIQUE INDEX oa1$$$.IKD301A1
ON oa1$$$.TKD301A1
("NAME" ASC
,MAJOR_VERSION ASC
,MINOR_VERSION ASC
)
NOT CLUSTER
NOT PADDED
DEFINE YES
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
DEFER NO
COPY NO
USING STOGROUP "GSMS "
PRIQTY -1
SECQTY -1
ERASE NO
FREEPAGE 0
PCTFREE 10
GBPCACHE CHANGED
PIECESIZE 2097152K;
CREATE TABLESPACE A302A
IN kd03$$$
USING STOGROUP "GSMS "
PRIQTY -1
SECQTY -1
ERASE NO
BUFFERPOOL BP2
CLOSE YES
LOCKMAX SYSTEM
SEGSIZE 64
FREEPAGE 0
PCTFREE 5
GBPCACHE CHANGED
DEFINE YES
LOGGED
TRACKMOD YES
COMPRESS YES
LOCKSIZE ANY
MAXROWS 255
CCSID EBCDIC;
CREATE TABLE oa1$$$.TKD302A1
(ID INTEGER
NOT NULL
GENERATED ALWAYS AS IDENTITY ( START WITH 1
, INCREMENT BY 1
, MINVALUE 1
, MAXVALUE 2147483647
, CACHE 20
, NOCYCLE
, NOORDER )
,"NAME" VARCHAR(256) FOR SBCS DATA
NOT NULL
,MAJOR_VERSION INTEGER
NOT NULL
,MINOR_VERSION INTEGER
NOT NULL
,CREATION_DATE DECIMAL(19, 0)
NOT NULL
,DISPLAY_NAME VARCHAR(256) FOR SBCS DATA
WITH DEFAULT NULL
,DESCRIPTION VARCHAR(256) FOR SBCS DATA
WITH DEFAULT NULL
,RULEAPP_ID INTEGER
NOT NULL
,CONSTRAINT CKD302A0 PRIMARY KEY
(ID
)
,CONSTRAINT CKD302A2 UNIQUE
(RULEAPP_ID
,"NAME"
,MAJOR_VERSION
,MINOR_VERSION
)
)
IN kd03$$$.A302A
APPEND NO
WITH RESTRICT ON DROP
NOT VOLATILE CARDINALITY
DATA CAPTURE CHANGES
AUDIT NONE
CCSID EBCDIC;
CREATE UNIQUE INDEX oa1$$$.IKD302A0
ON oa1$$$.TKD302A1
(ID ASC
)
NOT CLUSTER
DEFINE YES
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
DEFER NO
COPY NO
USING STOGROUP "GSMS "
PRIQTY -1
SECQTY -1
ERASE NO
FREEPAGE 0
PCTFREE 10
GBPCACHE CHANGED
PIECESIZE 2097152K;
CREATE UNIQUE INDEX oa1$$$.IKD302A1
ON oa1$$$.TKD302A1
(RULEAPP_ID ASC
,"NAME" ASC
,MAJOR_VERSION ASC
,MINOR_VERSION ASC
)
NOT CLUSTER
NOT PADDED
DEFINE YES
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
DEFER NO
COPY NO
USING STOGROUP "GSMS "
PRIQTY -1
SECQTY -1
ERASE NO
FREEPAGE 0
PCTFREE 10
GBPCACHE CHANGED
PIECESIZE 2097152K;
CREATE TABLESPACE A304A
IN kd03$$$
USING STOGROUP "GSMS "
PRIQTY -1
SECQTY -1
ERASE NO
BUFFERPOOL BP2
CLOSE YES
LOCKMAX SYSTEM
SEGSIZE 64
FREEPAGE 0
PCTFREE 5
GBPCACHE CHANGED
DEFINE YES
LOGGED
TRACKMOD YES
COMPRESS YES
LOCKSIZE ANY
MAXROWS 255
CCSID EBCDIC;
CREATE TABLE oa1$$$.TKD304A1
(ID INTEGER
NOT NULL
GENERATED ALWAYS AS IDENTITY ( START WITH 1
, INCREMENT BY 1
, MINVALUE 1
, MAXVALUE 2147483647
, CACHE 20
, NOCYCLE
, NOORDER )
,RULESET_ID INTEGER
NOT NULL
,"NAME" VARCHAR(256) FOR SBCS DATA
NOT NULL
,"VALUE" VARCHAR(2000) FOR SBCS DATA
NOT NULL
,CONSTRAINT CKD304A0 PRIMARY KEY
(ID
)
,CONSTRAINT CKD304A2 UNIQUE
(RULESET_ID
,"NAME"
)
)
IN kd03$$$.A304A
APPEND NO
WITH RESTRICT ON DROP
NOT VOLATILE CARDINALITY
DATA CAPTURE CHANGES
AUDIT NONE
CCSID EBCDIC;
CREATE UNIQUE INDEX oa1$$$.IKD304A0
ON oa1$$$.TKD304A1
(ID ASC
)
NOT CLUSTER
DEFINE YES
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
DEFER NO
COPY NO
USING STOGROUP "GSMS "
PRIQTY -1
SECQTY -1
ERASE NO
FREEPAGE 0
PCTFREE 10
GBPCACHE CHANGED
PIECESIZE 2097152K;
CREATE UNIQUE INDEX oa1$$$.IKD304A1
ON oa1$$$.TKD304A1
(RULESET_ID ASC
,"NAME" ASC
)
NOT CLUSTER
NOT PADDED
DEFINE YES
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
DEFER NO
COPY NO
USING STOGROUP "GSMS "
PRIQTY -1
SECQTY -1
ERASE NO
FREEPAGE 0
PCTFREE 10
GBPCACHE CHANGED
PIECESIZE 2097152K;
CREATE TABLESPACE A303A
IN kd03$$$
USING STOGROUP "GSMS "
PRIQTY -1
SECQTY -1
ERASE NO
BUFFERPOOL BP2
CLOSE YES
LOCKMAX SYSTEM
SEGSIZE 64
FREEPAGE 0
PCTFREE 5
GBPCACHE CHANGED
DEFINE YES
LOGGED
TRACKMOD YES
COMPRESS YES
LOCKSIZE ANY
MAXROWS 255
CCSID EBCDIC;
CREATE TABLE oa1$$$.TKD303A1
(ID INTEGER
NOT NULL
GENERATED ALWAYS AS IDENTITY ( START WITH 1
, INCREMENT BY 1
, MINVALUE 1
, MAXVALUE 2147483647
, CACHE 20
, NOCYCLE
, NOORDER )
,RULEAPP_ID INTEGER
NOT NULL
,"NAME" VARCHAR(256) FOR SBCS DATA
NOT NULL
,"VALUE" VARCHAR(2000) FOR SBCS DATA
NOT NULL
,CONSTRAINT CKD303A0 PRIMARY KEY
(ID
)
,CONSTRAINT CKD303A2 UNIQUE
(RULEAPP_ID
,"NAME"
)
)
IN kd03$$$.A303A
APPEND NO
WITH RESTRICT ON DROP
NOT VOLATILE CARDINALITY
DATA CAPTURE CHANGES
AUDIT NONE
CCSID EBCDIC;
CREATE UNIQUE INDEX oa1$$$.IKD303A0
ON oa1$$$.TKD303A1
(ID ASC
)
NOT CLUSTER
DEFINE YES
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
DEFER NO
COPY NO
USING STOGROUP "GSMS "
PRIQTY -1
SECQTY -1
ERASE NO
FREEPAGE 0
PCTFREE 10
GBPCACHE CHANGED
PIECESIZE 2097152K;
CREATE UNIQUE INDEX oa1$$$.IKD303A1
ON oa1$$$.TKD303A1
(RULEAPP_ID ASC
,"NAME" ASC
)
NOT CLUSTER
NOT PADDED
DEFINE YES
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
DEFER NO
COPY NO
USING STOGROUP "GSMS "
PRIQTY -1
SECQTY -1
ERASE NO
FREEPAGE 0
PCTFREE 10
GBPCACHE CHANGED
PIECESIZE 2097152K;
CREATE TABLESPACE A305A
IN kd03$$$
USING STOGROUP "GSMS "
PRIQTY -1
SECQTY -1
ERASE NO
BUFFERPOOL BP2
CLOSE YES
LOCKMAX SYSTEM
SEGSIZE 64
FREEPAGE 0
PCTFREE 5
GBPCACHE CHANGED
DEFINE YES
LOGGED
TRACKMOD YES
COMPRESS YES
LOCKSIZE ANY
MAXROWS 255
CCSID EBCDIC;
CREATE TABLE oa1$$$.TKD305A1
(ID INTEGER
NOT NULL
GENERATED ALWAYS AS IDENTITY ( START WITH 1
, INCREMENT BY 1
, MINVALUE 1
, MAXVALUE 2147483647
, CACHE 20
, NOCYCLE
, NOORDER )
,RULESET_ID INTEGER
NOT NULL
,ARCHIVE BLOB(1G)
NOT NULL
,CONSTRAINT CKD305A0 PRIMARY KEY
(ID
)
)
IN kd03$$$.A305A
APPEND NO
WITH RESTRICT ON DROP
NOT VOLATILE CARDINALITY
DATA CAPTURE CHANGES
AUDIT NONE
CCSID EBCDIC;
CREATE UNIQUE INDEX oa1$$$.IKD305A0
ON oa1$$$.TKD305A1
(ID ASC
)
NOT CLUSTER
DEFINE YES
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
DEFER NO
COPY NO
USING STOGROUP "GSMS "
PRIQTY -1
SECQTY -1
ERASE NO
FREEPAGE 0
PCTFREE 10
GBPCACHE CHANGED
PIECESIZE 2097152K;
CREATE LOB TABLESPACE A306A
IN kd03$$$
USING STOGROUP "GSMS "
PRIQTY -1
SECQTY -1
ERASE NO
BUFFERPOOL BP8
DSSIZE 16G
CLOSE YES
LOCKMAX SYSTEM
GBPCACHE CHANGED
DEFINE YES
LOGGED
LOCKSIZE ANY;
CREATE AUXILIARY TABLE oa1$$$.TKD306A1
IN kd03$$$.A306A
STORES oa1$$$.TKD305A1
APPEND NO
COLUMN ARCHIVE;
CREATE UNIQUE INDEX oa1$$$.IKD306A0
ON oa1$$$.TKD306A1
PADDED
DEFINE YES
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
COPY NO
USING STOGROUP "GSMS "
PRIQTY -1
SECQTY -1
ERASE NO
FREEPAGE 0
PCTFREE 10
GBPCACHE CHANGED
PIECESIZE 4194304K;
CREATE TABLESPACE A311A
IN kd03$$$
USING STOGROUP "GSMS "
PRIQTY -1
SECQTY -1
ERASE NO
BUFFERPOOL BP2
CLOSE YES
LOCKMAX SYSTEM
SEGSIZE 64
FREEPAGE 0
PCTFREE 5
GBPCACHE CHANGED
DEFINE YES
LOGGED
TRACKMOD YES
COMPRESS YES
LOCKSIZE ANY
MAXROWS 255
CCSID EBCDIC;
CREATE TABLE oa1$$$.TKD311A1
(ID INTEGER
NOT NULL
GENERATED ALWAYS AS IDENTITY ( START WITH 1
, INCREMENT BY 1
, MINVALUE 1
, MAXVALUE 2147483647
, CACHE 20
, NOCYCLE
, NOORDER )
,"NAME" VARCHAR(256) FOR SBCS DATA
NOT NULL
,MAJOR_VERSION INTEGER
NOT NULL
,MINOR_VERSION INTEGER
NOT NULL
,CREATION_DATE DECIMAL(19, 0)
NOT NULL
,DISPLAY_NAME VARCHAR(256) FOR SBCS DATA
WITH DEFAULT NULL
,DESCRIPTION VARCHAR(256) FOR SBCS DATA
WITH DEFAULT NULL
,CONSTRAINT CKD311A0 PRIMARY KEY
(ID
)
,CONSTRAINT CKD311A1 UNIQUE
("NAME"
,MAJOR_VERSION
,MINOR_VERSION
)
)
IN kd03$$$.A311A
APPEND NO
WITH RESTRICT ON DROP
NOT VOLATILE CARDINALITY
DATA CAPTURE CHANGES
AUDIT NONE
CCSID EBCDIC;
CREATE UNIQUE INDEX oa1$$$.IKD311A0
ON oa1$$$.TKD311A1
(ID ASC
)
NOT CLUSTER
DEFINE YES
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
DEFER NO
COPY NO
USING STOGROUP "GSMS "
PRIQTY -1
SECQTY -1
ERASE NO
FREEPAGE 0
PCTFREE 10
GBPCACHE CHANGED
PIECESIZE 2097152K;
CREATE UNIQUE INDEX oa1$$$.IKD311A1
ON oa1$$$.TKD311A1
("NAME" ASC
,MAJOR_VERSION ASC
,MINOR_VERSION ASC
)
NOT CLUSTER
NOT PADDED
DEFINE YES
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
DEFER NO
COPY NO
USING STOGROUP "GSMS "
PRIQTY -1
SECQTY -1
ERASE NO
FREEPAGE 0
PCTFREE 10
GBPCACHE CHANGED
PIECESIZE 2097152K;
CREATE TABLESPACE A312A
IN kd03$$$
USING STOGROUP "GSMS "
PRIQTY -1
SECQTY -1
ERASE NO
BUFFERPOOL BP2
CLOSE YES
LOCKMAX SYSTEM
SEGSIZE 64
FREEPAGE 0
PCTFREE 5
GBPCACHE CHANGED
DEFINE YES
LOGGED
TRACKMOD YES
COMPRESS YES
LOCKSIZE ANY
MAXROWS 255
CCSID EBCDIC;
CREATE TABLE oa1$$$.TKD312A1
(ID INTEGER
NOT NULL
GENERATED ALWAYS AS IDENTITY ( START WITH 1
, INCREMENT BY 1
, MINVALUE 1
, MAXVALUE 2147483647
, CACHE 20
, NOCYCLE
, NOORDER )
,"NAME" VARCHAR(256) FOR SBCS DATA
NOT NULL
,MAJOR_VERSION INTEGER
NOT NULL
,MINOR_VERSION INTEGER
NOT NULL
,CREATION_DATE DECIMAL(19, 0)
NOT NULL
,DISPLAY_NAME VARCHAR(256) FOR SBCS DATA
WITH DEFAULT NULL
,DESCRIPTION VARCHAR(256) FOR SBCS DATA
WITH DEFAULT NULL
,RULEAPP_ID INTEGER
NOT NULL
,CONSTRAINT CKD312A0 PRIMARY KEY
(ID
)
,CONSTRAINT CKD312A2 UNIQUE
(RULEAPP_ID
,"NAME"
,MAJOR_VERSION
,MINOR_VERSION
)
)
IN kd03$$$.A312A
APPEND NO
WITH RESTRICT ON DROP
NOT VOLATILE CARDINALITY
DATA CAPTURE CHANGES
AUDIT NONE
CCSID EBCDIC;
CREATE UNIQUE INDEX oa1$$$.IKD312A0
ON oa1$$$.TKD312A1
(ID ASC
)
NOT CLUSTER
DEFINE YES
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
DEFER NO
COPY NO
USING STOGROUP "GSMS "
PRIQTY -1
SECQTY -1
ERASE NO
FREEPAGE 0
PCTFREE 10
GBPCACHE CHANGED
PIECESIZE 2097152K;
CREATE UNIQUE INDEX oa1$$$.IKD312A1
ON oa1$$$.TKD312A1
(RULEAPP_ID ASC
,"NAME" ASC
,MAJOR_VERSION ASC
,MINOR_VERSION ASC
)
NOT CLUSTER
NOT PADDED
DEFINE YES
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
DEFER NO
COPY NO
USING STOGROUP "GSMS "
PRIQTY -1
SECQTY -1
ERASE NO
FREEPAGE 0
PCTFREE 10
GBPCACHE CHANGED
PIECESIZE 2097152K;
CREATE TABLESPACE A314A
IN kd03$$$
USING STOGROUP "GSMS "
PRIQTY -1
SECQTY -1
ERASE NO
BUFFERPOOL BP2
CLOSE YES
LOCKMAX SYSTEM
SEGSIZE 64
FREEPAGE 0
PCTFREE 5
GBPCACHE CHANGED
DEFINE YES
LOGGED
TRACKMOD YES
COMPRESS YES
LOCKSIZE ANY
MAXROWS 255
CCSID EBCDIC;
CREATE TABLE oa1$$$.TKD314A1
(ID INTEGER
NOT NULL
GENERATED ALWAYS AS IDENTITY ( START WITH 1
, INCREMENT BY 1
, MINVALUE 1
, MAXVALUE 2147483647
, CACHE 20
, NOCYCLE
, NOORDER )
,RULESET_ID INTEGER
NOT NULL
,"NAME" VARCHAR(256) FOR SBCS DATA
NOT NULL
,"VALUE" VARCHAR(2000) FOR SBCS DATA
NOT NULL
,CONSTRAINT CKD314A0 PRIMARY KEY
(ID
)
,CONSTRAINT CKD314A2 UNIQUE
(RULESET_ID
,"NAME"
)
)
IN kd03$$$.A314A
APPEND NO
WITH RESTRICT ON DROP
NOT VOLATILE CARDINALITY
DATA CAPTURE CHANGES
AUDIT NONE
CCSID EBCDIC;
CREATE UNIQUE INDEX oa1$$$.IKD314A0
ON oa1$$$.TKD314A1
(ID ASC
)
NOT CLUSTER
DEFINE YES
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
DEFER NO
COPY NO
USING STOGROUP "GSMS "
PRIQTY -1
SECQTY -1
ERASE NO
FREEPAGE 0
PCTFREE 10
GBPCACHE CHANGED
PIECESIZE 2097152K;
CREATE UNIQUE INDEX oa1$$$.IKD314A1
ON oa1$$$.TKD314A1
(RULESET_ID ASC
,"NAME" ASC
)
NOT CLUSTER
NOT PADDED
DEFINE YES
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
DEFER NO
COPY NO
USING STOGROUP "GSMS "
PRIQTY -1
SECQTY -1
ERASE NO
FREEPAGE 0
PCTFREE 10
GBPCACHE CHANGED
PIECESIZE 2097152K;
CREATE TABLESPACE A313A
IN kd03$$$
USING STOGROUP "GSMS "
PRIQTY -1
SECQTY -1
ERASE NO
BUFFERPOOL BP2
CLOSE YES
LOCKMAX SYSTEM
SEGSIZE 64
FREEPAGE 0
PCTFREE 5
GBPCACHE CHANGED
DEFINE YES
LOGGED
TRACKMOD YES
COMPRESS YES
LOCKSIZE ANY
MAXROWS 255
CCSID EBCDIC;
CREATE TABLE oa1$$$.TKD313A1
(ID INTEGER
NOT NULL
GENERATED ALWAYS AS IDENTITY ( START WITH 1
, INCREMENT BY 1
, MINVALUE 1
, MAXVALUE 2147483647
, CACHE 20
, NOCYCLE
, NOORDER )
,RULEAPP_ID INTEGER
NOT NULL
,"NAME" VARCHAR(256) FOR SBCS DATA
NOT NULL
,"VALUE" VARCHAR(2000) FOR SBCS DATA
NOT NULL
,CONSTRAINT CKD313A0 PRIMARY KEY
(ID
)
,CONSTRAINT CKD313A2 UNIQUE
(RULEAPP_ID
,"NAME"
)
)
IN kd03$$$.A313A
APPEND NO
WITH RESTRICT ON DROP
NOT VOLATILE CARDINALITY
DATA CAPTURE CHANGES
AUDIT NONE
CCSID EBCDIC;
CREATE UNIQUE INDEX oa1$$$.IKD313A0
ON oa1$$$.TKD313A1
(ID ASC
)
NOT CLUSTER
DEFINE YES
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
DEFER NO
COPY NO
USING STOGROUP "GSMS "
PRIQTY -1
SECQTY -1
ERASE NO
FREEPAGE 0
PCTFREE 10
GBPCACHE CHANGED
PIECESIZE 2097152K;
CREATE UNIQUE INDEX oa1$$$.IKD313A1
ON oa1$$$.TKD313A1
(RULEAPP_ID ASC
,"NAME" ASC
)
NOT CLUSTER
NOT PADDED
DEFINE YES
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
DEFER NO
COPY NO
USING STOGROUP "GSMS "
PRIQTY -1
SECQTY -1
ERASE NO
FREEPAGE 0
PCTFREE 10
GBPCACHE CHANGED
PIECESIZE 2097152K;
CREATE TABLESPACE A315A
IN kd03$$$
USING STOGROUP "GSMS "
PRIQTY -1
SECQTY -1
ERASE NO
BUFFERPOOL BP2
CLOSE YES
LOCKMAX SYSTEM
SEGSIZE 64
FREEPAGE 0
PCTFREE 5
GBPCACHE CHANGED
DEFINE YES
LOGGED
TRACKMOD YES
COMPRESS YES
LOCKSIZE ANY
MAXROWS 255
CCSID EBCDIC;
CREATE TABLE oa1$$$.TKD315A1
(ID INTEGER
NOT NULL
GENERATED ALWAYS AS IDENTITY ( START WITH 1
, INCREMENT BY 1
, MINVALUE 1
, MAXVALUE 2147483647
, CACHE 20
, NOCYCLE
, NOORDER )
,RULESET_ID INTEGER
NOT NULL
,ARCHIVE BLOB(1G)
NOT NULL
,CONSTRAINT CKD315A0 PRIMARY KEY
(ID
)
)
IN kd03$$$.A315A
APPEND NO
WITH RESTRICT ON DROP
NOT VOLATILE CARDINALITY
DATA CAPTURE CHANGES
AUDIT NONE
CCSID EBCDIC;
CREATE UNIQUE INDEX oa1$$$.IKD315A0
ON oa1$$$.TKD315A1
(ID ASC
)
NOT CLUSTER
DEFINE YES
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
DEFER NO
COPY NO
USING STOGROUP "GSMS "
PRIQTY -1
SECQTY -1
ERASE NO
FREEPAGE 0
PCTFREE 10
GBPCACHE CHANGED
PIECESIZE 2097152K;
CREATE LOB TABLESPACE A316A
IN kd03$$$
USING STOGROUP "GSMS "
PRIQTY -1
SECQTY -1
ERASE NO
BUFFERPOOL BP8
DSSIZE 16G
CLOSE YES
LOCKMAX SYSTEM
GBPCACHE CHANGED
DEFINE YES
LOGGED
LOCKSIZE ANY;
CREATE AUXILIARY TABLE oa1$$$.TKD316A1
IN kd03$$$.A316A
STORES oa1$$$.TKD315A1
APPEND NO
COLUMN ARCHIVE;
CREATE UNIQUE INDEX oa1$$$.IKD316A0
ON oa1$$$.TKD316A1
PADDED
DEFINE YES
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
COPY NO
USING STOGROUP "GSMS "
PRIQTY -1
SECQTY -1
ERASE NO
FREEPAGE 0
PCTFREE 10
GBPCACHE CHANGED
PIECESIZE 4194304K;
CREATE TABLESPACE A331A
IN kd03$$$
USING STOGROUP "GSMS "
PRIQTY -1
SECQTY -1
ERASE NO
BUFFERPOOL BP2
CLOSE YES
LOCKMAX SYSTEM
SEGSIZE 64
FREEPAGE 0
PCTFREE 5
GBPCACHE CHANGED
DEFINE YES
LOGGED
TRACKMOD YES
COMPRESS YES
LOCKSIZE ANY
MAXROWS 255
CCSID EBCDIC;
CREATE TABLE oa1$$$.TKD331A1
(UUID VARCHAR(40) FOR SBCS DATA
NOT NULL
,TCN DECIMAL(19, 0)
NOT NULL
,MODIFICATION_TIME TIMESTAMP (6) WITHOUT TIME ZONE
NOT NULL
,PID VARCHAR(7) FOR SBCS DATA
NOT NULL
,PROPERTY VARCHAR(100) FOR SBCS DATA
NOT NULL
,"VALUE" VARCHAR(250) FOR SBCS DATA
NOT NULL
,CONSTRAINT CKD331A0 PRIMARY KEY
(UUID
)
,CONSTRAINT CKD331A1 UNIQUE
(PROPERTY
)
)
IN kd03$$$.A331A
APPEND NO
WITH RESTRICT ON DROP
NOT VOLATILE CARDINALITY
DATA CAPTURE CHANGES
AUDIT NONE
CCSID EBCDIC;
CREATE UNIQUE INDEX oa1$$$.IKD331A0
ON oa1$$$.TKD331A1
(UUID ASC
)
NOT PADDED
CLUSTER
DEFINE YES
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
DEFER NO
COPY NO
USING STOGROUP "GSMS "
PRIQTY -1
SECQTY -1
ERASE NO
FREEPAGE 0
PCTFREE 10
GBPCACHE CHANGED
PIECESIZE 2097152K;
CREATE UNIQUE INDEX oa1$$$.IKD331A1
ON oa1$$$.TKD331A1
(PROPERTY ASC
)
NOT CLUSTER
NOT PADDED
DEFINE YES
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
DEFER NO
COPY NO
USING STOGROUP "GSMS "
PRIQTY -1
SECQTY -1
ERASE NO
FREEPAGE 0
PCTFREE 10
GBPCACHE CHANGED
PIECESIZE 2097152K;
CREATE TABLESPACE A332A
IN kd03$$$
USING STOGROUP "GSMS "
PRIQTY -1
SECQTY -1
ERASE NO
BUFFERPOOL BP2
CLOSE YES
LOCKMAX SYSTEM
SEGSIZE 64
FREEPAGE 0
PCTFREE 5
GBPCACHE CHANGED
DEFINE YES
LOGGED
TRACKMOD YES
COMPRESS YES
LOCKSIZE ANY
MAXROWS 255
CCSID EBCDIC;
CREATE TABLE oa1$$$.TKD332A1
(UUID VARCHAR(40) FOR SBCS DATA
NOT NULL
,TCN DECIMAL(19, 0)
NOT NULL
,MODIFICATION_TIME TIMESTAMP (6) WITHOUT TIME ZONE
NOT NULL
,PID VARCHAR(7) FOR SBCS DATA
NOT NULL
,RULE_CONTEXT VARCHAR(100) FOR SBCS DATA
NOT NULL
,CHANGED_ENTITY_UUID VARCHAR(40) FOR SBCS DATA
NOT NULL
,CHANGED_ENTITY_NAME VARCHAR(100) FOR SBCS DATA
NOT NULL
,ACTIVITY VARCHAR(50) FOR SBCS DATA
NOT NULL
,DETAILS VARCHAR(250) FOR SBCS DATA
WITH DEFAULT NULL
,CONSTRAINT CKD332A0 PRIMARY KEY
(UUID
)
)
IN kd03$$$.A332A
APPEND NO
WITH RESTRICT ON DROP
NOT VOLATILE CARDINALITY
DATA CAPTURE CHANGES
AUDIT NONE
CCSID EBCDIC;
CREATE UNIQUE INDEX oa1$$$.IKD332A0
ON oa1$$$.TKD332A1
(UUID ASC
)
NOT PADDED
CLUSTER
DEFINE YES
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
DEFER NO
COPY NO
USING STOGROUP "GSMS "
PRIQTY -1
SECQTY -1
ERASE NO
FREEPAGE 0
PCTFREE 10
GBPCACHE CHANGED
PIECESIZE 2097152K;
CREATE TABLESPACE A333A
IN kd03$$$
USING STOGROUP "GSMS "
PRIQTY -1
SECQTY -1
ERASE NO
BUFFERPOOL BP2
CLOSE YES
LOCKMAX SYSTEM
SEGSIZE 64
FREEPAGE 0
PCTFREE 5
GBPCACHE CHANGED
DEFINE YES
LOGGED
TRACKMOD YES
COMPRESS YES
LOCKSIZE ANY
MAXROWS 255
CCSID EBCDIC;
CREATE TABLE oa1$$$.TKD333A1
(UUID VARCHAR(40) FOR SBCS DATA
NOT NULL
,TCN DECIMAL(19, 0)
NOT NULL
,MODIFICATION_TIME TIMESTAMP (6) WITHOUT TIME ZONE
NOT NULL
,PID VARCHAR(7) FOR SBCS DATA
WITH DEFAULT NULL
,"NAME" VARCHAR(80) FOR SBCS DATA
NOT NULL
,"VALUE" VARCHAR(250) FOR SBCS DATA
NOT NULL
,CONSTRAINT CKD333A0 PRIMARY KEY
(UUID
)
)
IN kd03$$$.A333A
APPEND NO
WITH RESTRICT ON DROP
NOT VOLATILE CARDINALITY
DATA CAPTURE CHANGES
AUDIT NONE
CCSID EBCDIC;
CREATE UNIQUE INDEX oa1$$$.IKD333A0
ON oa1$$$.TKD333A1
(UUID ASC
)
NOT PADDED
CLUSTER
DEFINE YES
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
DEFER NO
COPY NO
USING STOGROUP "GSMS "
PRIQTY -1
SECQTY -1
ERASE NO
FREEPAGE 0
PCTFREE 10
GBPCACHE CHANGED
PIECESIZE 2097152K;
CREATE TABLESPACE A334A
IN kd03$$$
USING STOGROUP "GSMS "
PRIQTY -1
SECQTY -1
ERASE NO
BUFFERPOOL BP2
CLOSE YES
LOCKMAX SYSTEM
SEGSIZE 64
FREEPAGE 0
PCTFREE 5
GBPCACHE CHANGED
DEFINE YES
LOGGED
TRACKMOD YES
COMPRESS YES
LOCKSIZE ANY
MAXROWS 255
CCSID EBCDIC;
CREATE TABLE oa1$$$.TKD334A1
(ACTIVITY_LOG VARCHAR(40) FOR SBCS DATA
NOT NULL
,ACTIVITY_LOG_DETAIL VARCHAR(40) FOR SBCS DATA
NOT NULL
)
IN kd03$$$.A334A
APPEND NO
WITH RESTRICT ON DROP
NOT VOLATILE CARDINALITY
DATA CAPTURE CHANGES
AUDIT NONE
CCSID EBCDIC;
CREATE INDEX oa1$$$.IKD334A1
ON oa1$$$.TKD334A1
(ACTIVITY_LOG ASC
)
NOT PADDED
CLUSTER
DEFINE YES
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
DEFER NO
COPY NO
USING STOGROUP "GSMS "
PRIQTY -1
SECQTY -1
ERASE NO
FREEPAGE 0
PCTFREE 10
GBPCACHE CHANGED
PIECESIZE 2097152K;
CREATE INDEX oa1$$$.IKD334A2
ON oa1$$$.TKD334A1
(ACTIVITY_LOG_DETAIL ASC
)
NOT CLUSTER
NOT PADDED
DEFINE YES
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
DEFER NO
COPY NO
USING STOGROUP "GSMS "
PRIQTY -1
SECQTY -1
ERASE NO
FREEPAGE 0
PCTFREE 10
GBPCACHE CHANGED
PIECESIZE 2097152K;
CREATE TABLESPACE A335A
IN kd03$$$
USING STOGROUP "GSMS "
PRIQTY -1
SECQTY -1
ERASE NO
BUFFERPOOL BP2
CLOSE YES
LOCKMAX SYSTEM
SEGSIZE 64
FREEPAGE 0
PCTFREE 5
GBPCACHE CHANGED
DEFINE YES
LOGGED
TRACKMOD YES
COMPRESS YES
LOCKSIZE ANY
MAXROWS 255
CCSID EBCDIC;
CREATE TABLE oa1$$$.TKD335A1
(UUID VARCHAR(40) FOR SBCS DATA
NOT NULL
,TCN DECIMAL(19, 0)
NOT NULL
,MODIFICATION_TIME TIMESTAMP (6) WITHOUT TIME ZONE
NOT NULL
,PID VARCHAR(7) FOR SBCS DATA
NOT NULL
,RULE_CONTEXT VARCHAR(50) FOR SBCS DATA
NOT NULL
,RULEAPP_NAME VARCHAR(250) FOR SBCS DATA
NOT NULL
,RULEAPP_VERSION_MAJOR DECIMAL(19, 0)
NOT NULL
,RULEAPP_VERSION_MINOR DECIMAL(19, 0)
NOT NULL
,BASELINE VARCHAR(100) FOR SBCS DATA
NOT NULL
,VALID_FROM TIMESTAMP (6) WITHOUT TIME ZONE
WITH DEFAULT NULL
,VALID_TO TIMESTAMP (6) WITHOUT TIME ZONE
WITH DEFAULT NULL
,JRULES_VERSION VARCHAR(10) FOR SBCS DATA
NOT NULL
,TARGET VARCHAR(10) FOR SBCS DATA
NOT NULL
,TRACE_ENABLED CHARACTER(1) FOR SBCS DATA
NOT NULL
,KPI_ENABLED CHARACTER(1) FOR SBCS DATA
NOT NULL
,STATUS VARCHAR(50) FOR SBCS DATA
NOT NULL
,ACCESS_LOCK VARCHAR(30) FOR SBCS DATA
WITH DEFAULT NULL
,CONSTRAINT CKD335A0 PRIMARY KEY
(UUID
)
,CONSTRAINT CKD335A1 UNIQUE
(RULE_CONTEXT
,RULEAPP_NAME
,RULEAPP_VERSION_MAJOR
,RULEAPP_VERSION_MINOR
,BASELINE
,TARGET
)
,CONSTRAINT CKD335A2 CHECK
(TARGET IN ( 'Production' , 'Test' )
)
,CONSTRAINT CKD335A3 CHECK
(KPI_ENABLED IN ( 'Y' , 'N' )
)
,CONSTRAINT CKD335A4 CHECK
(TRACE_ENABLED IN ( 'Y' , 'N' )
)
)
IN kd03$$$.A335A
APPEND NO
WITH RESTRICT ON DROP
NOT VOLATILE CARDINALITY
DATA CAPTURE CHANGES
AUDIT NONE
CCSID EBCDIC;
CREATE UNIQUE INDEX oa1$$$.IKD335A0
ON oa1$$$.TKD335A1
(UUID ASC
)
NOT PADDED
CLUSTER
DEFINE YES
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
DEFER NO
COPY NO
USING STOGROUP "GSMS "
PRIQTY -1
SECQTY -1
ERASE NO
FREEPAGE 0
PCTFREE 10
GBPCACHE CHANGED
PIECESIZE 2097152K;
CREATE UNIQUE INDEX oa1$$$.IKD335A1
ON oa1$$$.TKD335A1
(RULE_CONTEXT ASC
,RULEAPP_NAME ASC
,RULEAPP_VERSION_MAJOR ASC
,RULEAPP_VERSION_MINOR ASC
,BASELINE ASC
,TARGET ASC
)
NOT CLUSTER
NOT PADDED
DEFINE YES
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
DEFER NO
COPY NO
USING STOGROUP "GSMS "
PRIQTY -1
SECQTY -1
ERASE NO
FREEPAGE 0
PCTFREE 10
GBPCACHE CHANGED
PIECESIZE 2097152K;
CREATE TABLESPACE A336A
IN kd03$$$
USING STOGROUP "GSMS "
PRIQTY -1
SECQTY -1
ERASE NO
BUFFERPOOL BP2
CLOSE YES
LOCKMAX SYSTEM
SEGSIZE 64
FREEPAGE 0
PCTFREE 5
GBPCACHE CHANGED
DEFINE YES
LOGGED
TRACKMOD YES
COMPRESS YES
LOCKSIZE ANY
MAXROWS 255
CCSID EBCDIC;
CREATE TABLE oa1$$$.TKD336A1
(UUID VARCHAR(40) FOR SBCS DATA
NOT NULL
,TCN DECIMAL(19, 0)
NOT NULL
,MODIFICATION_TIME TIMESTAMP (6) WITHOUT TIME ZONE
NOT NULL
,PID VARCHAR(7) FOR SBCS DATA
NOT NULL
,USER_PID VARCHAR(7) FOR SBCS DATA
NOT NULL
,RULE_CONTEXT VARCHAR(50) FOR SBCS DATA
NOT NULL
,BRINFRA_ROLE VARCHAR(50) FOR SBCS DATA
NOT NULL
,CONSTRAINT CKD336A0 PRIMARY KEY
(UUID
)
,CONSTRAINT CKD336A1 UNIQUE
(USER_PID
,RULE_CONTEXT
,BRINFRA_ROLE
)
)
IN kd03$$$.A336A
APPEND NO
WITH RESTRICT ON DROP
NOT VOLATILE CARDINALITY
DATA CAPTURE CHANGES
AUDIT NONE
CCSID EBCDIC;
CREATE UNIQUE INDEX oa1$$$.IKD336A0
ON oa1$$$.TKD336A1
(UUID ASC
)
NOT PADDED
CLUSTER
DEFINE YES
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
DEFER NO
COPY NO
USING STOGROUP "GSMS "
PRIQTY -1
SECQTY -1
ERASE NO
FREEPAGE 0
PCTFREE 10
GBPCACHE CHANGED
PIECESIZE 2097152K;
CREATE UNIQUE INDEX oa1$$$.IKD336A1
ON oa1$$$.TKD336A1
(USER_PID ASC
,RULE_CONTEXT ASC
,BRINFRA_ROLE ASC
)
NOT CLUSTER
NOT PADDED
DEFINE YES
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
DEFER NO
COPY NO
USING STOGROUP "GSMS "
PRIQTY -1
SECQTY -1
ERASE NO
FREEPAGE 0
PCTFREE 10
GBPCACHE CHANGED
PIECESIZE 2097152K;
CREATE TABLESPACE A337A
IN kd03$$$
USING STOGROUP "GSMS "
PRIQTY -1
SECQTY -1
ERASE NO
BUFFERPOOL BP2
CLOSE YES
LOCKMAX SYSTEM
SEGSIZE 64
FREEPAGE 0
PCTFREE 5
GBPCACHE CHANGED
DEFINE YES
LOGGED
TRACKMOD YES
COMPRESS YES
LOCKSIZE ANY
MAXROWS 255
CCSID EBCDIC;
CREATE TABLE oa1$$$.TKD337A1
(ID INTEGER
NOT NULL
GENERATED ALWAYS AS IDENTITY ( START WITH 1
, INCREMENT BY 1
, MINVALUE 1
, MAXVALUE 2147483647
, CACHE 20
, NOCYCLE
, NOORDER )
,COMMAND_TYPE VARCHAR(20) FOR SBCS DATA
,SENDER_ID VARCHAR(250) FOR SBCS DATA
,CLIENT_ID VARCHAR(250) FOR SBCS DATA
,TARGET VARCHAR(8) FOR SBCS DATA
,PAYLOAD CLOB(1G) FOR SBCS DATA
NOT NULL
,CONSTRAINT CKD337A0 PRIMARY KEY
(ID
)
)
IN kd03$$$.A337A
APPEND NO
WITH RESTRICT ON DROP
NOT VOLATILE CARDINALITY
DATA CAPTURE CHANGES
AUDIT NONE
CCSID EBCDIC;
CREATE UNIQUE INDEX oa1$$$.IKD337A0
ON oa1$$$.TKD337A1
(ID ASC
)
CLUSTER
DEFINE YES
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
DEFER NO
COPY NO
USING STOGROUP "GSMS "
PRIQTY -1
SECQTY -1
ERASE NO
FREEPAGE 0
PCTFREE 10
GBPCACHE CHANGED
PIECESIZE 2097152K;
CREATE LOB TABLESPACE A338A
IN kd03$$$
USING STOGROUP "GSMS "
PRIQTY -1
SECQTY -1
ERASE NO
BUFFERPOOL BP2
DSSIZE 16G
CLOSE YES
LOCKMAX SYSTEM
GBPCACHE CHANGED
DEFINE YES
LOGGED
LOCKSIZE ANY;
CREATE AUXILIARY TABLE oa1$$$.TKD338A1
IN kd03$$$.A338A
STORES oa1$$$.TKD337A1
APPEND NO
COLUMN PAYLOAD;
CREATE UNIQUE INDEX oa1$$$.IKD338A0
ON oa1$$$.TKD338A1
PADDED
DEFINE YES
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
COPY NO
USING STOGROUP "GSMS "
PRIQTY -1
SECQTY -1
ERASE NO
FREEPAGE 0
PCTFREE 10
GBPCACHE CHANGED
PIECESIZE 4194304K;
CREATE TABLESPACE A339A
IN kd03$$$
USING STOGROUP "GSMS "
PRIQTY -1
SECQTY -1
ERASE NO
BUFFERPOOL BP2
CLOSE YES
LOCKMAX SYSTEM
SEGSIZE 64
FREEPAGE 0
PCTFREE 5
GBPCACHE CHANGED
DEFINE YES
LOGGED
TRACKMOD YES
COMPRESS YES
LOCKSIZE ANY
MAXROWS 255
CCSID EBCDIC;
CREATE TABLE oa1$$$.TKD339A1
(UUID VARCHAR(40) FOR SBCS DATA
NOT NULL
,TCN DECIMAL(19, 0)
NOT NULL
,MODIFICATION_TIME TIMESTAMP (6) WITHOUT TIME ZONE
NOT NULL
,PID VARCHAR(7) FOR SBCS DATA
NOT NULL
,SERVER_NAME VARCHAR(50) FOR SBCS DATA
NOT NULL
,CLIENT_NAME VARCHAR(50) FOR SBCS DATA
NOT NULL
,COMPONENT_ID VARCHAR(250) FOR SBCS DATA
NOT NULL
,COMPONENT_PLATFORM VARCHAR(10) FOR SBCS DATA
NOT NULL
,COMPONENT_STAGE VARCHAR(10) FOR SBCS DATA
NOT NULL
,COMPONENT_TYPE VARCHAR(10) FOR SBCS DATA
NOT NULL
,RULE_CONTEXT VARCHAR(50) FOR SBCS DATA
NOT NULL
,RES_EXECUTION_MODE VARCHAR(10) FOR SBCS DATA
NOT NULL
,RES_PERSISTENCE_TYPE VARCHAR(10) FOR SBCS DATA
NOT NULL
,RES_DATASOURCE VARCHAR(250) FOR SBCS DATA
WITH DEFAULT NULL
,RES_EXECUTION_ENV VARCHAR(10) FOR SBCS DATA
NOT NULL
,COMPATIBLE_RULEAPPS VARCHAR(250) FOR SBCS DATA
WITH DEFAULT NULL
,PRELOAD_RULEAPPS VARCHAR(250) FOR SBCS DATA
WITH DEFAULT NULL
,CLIENT_STARTED_AT TIMESTAMP (6) WITHOUT TIME ZONE
NOT NULL
,LAST_QUERY_TIMESTAMP TIMESTAMP (6) WITHOUT TIME ZONE
NOT NULL
,DEAD_COUNT DECIMAL(6, 0)
NOT NULL
,CONSTRAINT CKD339A0 PRIMARY KEY
(UUID
)
,CONSTRAINT CKD339A1 CHECK
(RES_EXECUTION_MODE IN ( 'JEE' , 'JSE' )
)
,CONSTRAINT CKD339A2 CHECK
(RES_PERSISTENCE_TYPE IN ( 'DS' , 'FILE' )
)
,CONSTRAINT CKD339A3 CHECK
(RES_EXECUTION_ENV IN ( 'Production' , 'Simulation' )
)
)
IN kd03$$$.A339A
APPEND NO
WITH RESTRICT ON DROP
NOT VOLATILE CARDINALITY
DATA CAPTURE CHANGES
AUDIT NONE
CCSID EBCDIC;
CREATE INDEX oa1$$$.IKD339A1
ON oa1$$$.TKD339A1
(RULE_CONTEXT ASC
)
NOT CLUSTER
NOT PADDED
DEFINE YES
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
DEFER NO
COPY NO
USING STOGROUP "GSMS "
PRIQTY -1
SECQTY -1
ERASE NO
FREEPAGE 0
PCTFREE 10
GBPCACHE CHANGED
PIECESIZE 2097152K;
CREATE UNIQUE INDEX oa1$$$.IKD339A0
ON oa1$$$.TKD339A1
(UUID ASC
)
NOT PADDED
CLUSTER
DEFINE YES
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
DEFER NO
COPY NO
USING STOGROUP "GSMS "
PRIQTY -1
SECQTY -1
ERASE NO
FREEPAGE 0
PCTFREE 10
GBPCACHE CHANGED
PIECESIZE 2097152K;
ALTER TABLE oa1$$$.TKD302A1
ADD
CONSTRAINT CKD302A1
FOREIGN KEY
(RULEAPP_ID
)
REFERENCES oa1$$$.TKD301A1 ON DELETE CASCADE
ENFORCED;
ALTER TABLE oa1$$$.TKD304A1
ADD
CONSTRAINT CKD304A1
FOREIGN KEY
(RULESET_ID
)
REFERENCES oa1$$$.TKD302A1 ON DELETE CASCADE
ENFORCED;
ALTER TABLE oa1$$$.TKD303A1
ADD
CONSTRAINT CKD303A1
FOREIGN KEY
(RULEAPP_ID
)
REFERENCES oa1$$$.TKD301A1 ON DELETE CASCADE
ENFORCED;
ALTER TABLE oa1$$$.TKD305A1
ADD
CONSTRAINT CKD305A1
FOREIGN KEY
(RULESET_ID
)
REFERENCES oa1$$$.TKD302A1 ON DELETE CASCADE
ENFORCED;
ALTER TABLE oa1$$$.TKD312A1
ADD
CONSTRAINT CKD312A1
FOREIGN KEY
(RULEAPP_ID
)
REFERENCES oa1$$$.TKD311A1 ON DELETE CASCADE
ENFORCED;
ALTER TABLE oa1$$$.TKD314A1
ADD
CONSTRAINT CKD314A1
FOREIGN KEY
(RULESET_ID
)
REFERENCES oa1$$$.TKD312A1 ON DELETE CASCADE
ENFORCED;
ALTER TABLE oa1$$$.TKD313A1
ADD
CONSTRAINT CKD313A1
FOREIGN KEY
(RULEAPP_ID
)
REFERENCES oa1$$$.TKD311A1 ON DELETE CASCADE
ENFORCED;
ALTER TABLE oa1$$$.TKD315A1
ADD
CONSTRAINT CKD315A1
FOREIGN KEY
(RULESET_ID
)
REFERENCES oa1$$$.TKD312A1 ON DELETE CASCADE
ENFORCED;
ALTER TABLE oa1$$$.TKD334A1
ADD
CONSTRAINT CKD334A1
FOREIGN KEY
(ACTIVITY_LOG
)
REFERENCES oa1$$$.TKD332A1 ON DELETE CASCADE
ENFORCED;
ALTER TABLE oa1$$$.TKD334A1
ADD
CONSTRAINT CKD334A2
FOREIGN KEY
(ACTIVITY_LOG_DETAIL
)
REFERENCES oa1$$$.TKD333A1 ON DELETE CASCADE
ENFORCED;