zOs/SQL/WQX13
set current sqlid = 'S100447';
xrop INDEX OA1P.IWQX13A002 ;
xrop INDEX OA1P.IWQX13A003 ;
commit;
;
CREATE INDEX OA1P.IWQX13A005
ON OA1P.TWQX13A1
(MS_FK_MO_UUID 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;
;
commit;
;x; rebind rzz nur x13
rebind package (WQ.YWQXCU.(CUBE000229))
rebind package (WQ.YWQXCU.(CUBE000220))
rebind package (WQ.YWQXCU.(CUBE000230))
rebind package (WQ.YWQXCU.(CUBE000232))
rebind package (WQ.YWQXCU.(CUBE000239))
rebind package (WQ.YWQXCU.(CUBE000247))
rebind package (WQ.YWQXCU.(CUBE000252))
rebind package (WQ.YWQXCU.(CUBE000254))
rebind package (WQ.YWQXIS.(CUBE000229))
rebind package (WQ.YWQXIS.(CUBE000220))
rebind package (WQ.YWQXIS.(CUBE000230))
rebind package (WQ.YWQXIS.(CUBE000232))
rebind package (WQ.YWQXIS.(CUBE000239))
rebind package (WQ.YWQXIS.(CUBE000247))
rebind package (WQ.YWQXUP.(CUBE000229))
rebind package (WQ.YWQXUP.(CUBE000220))
rebind package (WQ.YWQXUP.(CUBE000230))
rebind package (WQ.YWQXUP.(CUBE000232))
rebind package (WQ.YWQXUP.(CUBE000239))
rebind package (WQ.YWQXUP.(CUBE000247))
;x; rebind rzz x13 und x14
REBIND PACKAGE(WQ.YWQXCU.(CUBE000220))
REBIND PACKAGE(WQ.YWQXCU.(CUBE000229))
REBIND PACKAGE(WQ.YWQXCU.(CUBE000230))
REBIND PACKAGE(WQ.YWQXCU.(CUBE000232))
REBIND PACKAGE(WQ.YWQXCU.(CUBE000239))
REBIND PACKAGE(WQ.YWQXCU.(CUBE000247))
REBIND PACKAGE(WQ.YWQXCU.(CUBE000252))
REBIND PACKAGE(WQ.YWQXCU.(CUBE000254))
REBIND PACKAGE(WQ.YWQXIS.(CUBE000220))
REBIND PACKAGE(WQ.YWQXIS.(CUBE000229))
REBIND PACKAGE(WQ.YWQXIS.(CUBE000230))
REBIND PACKAGE(WQ.YWQXIS.(CUBE000232))
REBIND PACKAGE(WQ.YWQXIS.(CUBE000239))
REBIND PACKAGE(WQ.YWQXIS.(CUBE000247))
REBIND PACKAGE(WQ.YWQXSL.(CUBE000220))
REBIND PACKAGE(WQ.YWQXSL.(CUBE000229))
REBIND PACKAGE(WQ.YWQXSL.(CUBE000230))
REBIND PACKAGE(WQ.YWQXSL.(CUBE000232))
REBIND PACKAGE(WQ.YWQXSL.(CUBE000236))
REBIND PACKAGE(WQ.YWQXSL.(CUBE000239))
REBIND PACKAGE(WQ.YWQXSL.(CUBE000247))
REBIND PACKAGE(WQ.YWQXUP.(CUBE000220))
REBIND PACKAGE(WQ.YWQXUP.(CUBE000229))
REBIND PACKAGE(WQ.YWQXUP.(CUBE000230))
REBIND PACKAGE(WQ.YWQXUP.(CUBE000232))
REBIND PACKAGE(WQ.YWQXUP.(CUBE000239))
REBIND PACKAGE(WQ.YWQXUP.(CUBE000247))
;x; rebind rz2
rz2ind PACKAGE(WQ.YWQXCU.(CUBE000220))
rz2ind PACKAGE(WQ.YWQXCU.(CUBE000230))
rz2ind PACKAGE(WQ.YWQXCU.(CUBE000232))
rz2ind PACKAGE(WQ.YWQXCU.(CUBE000239))
rz2ind PACKAGE(WQ.YWQXCU.(CUBE000247))
rz2ind PACKAGE(WQ.YWQXCU.(CUBE000254))
rz2ind PACKAGE(WQ.YWQXIS.(CUBE000220))
rz2ind PACKAGE(WQ.YWQXIS.(CUBE000230))
rz2ind PACKAGE(WQ.YWQXIS.(CUBE000232))
rz2ind PACKAGE(WQ.YWQXIS.(CUBE000239))
rz2ind PACKAGE(WQ.YWQXIS.(CUBE000247))
rz2ind PACKAGE(WQ.YWQXSL.(CUBE000220))
rz2ind PACKAGE(WQ.YWQXSL.(CUBE000230))
rz2ind PACKAGE(WQ.YWQXSL.(CUBE000232))
rz2ind PACKAGE(WQ.YWQXSL.(CUBE000236))
rz2ind PACKAGE(WQ.YWQXSL.(CUBE000239))
rz2ind PACKAGE(WQ.YWQXSL.(CUBE000247))
rz2ind PACKAGE(WQ.YWQXUP.(CUBE000220))
rz2ind PACKAGE(WQ.YWQXUP.(CUBE000230))
rz2ind PACKAGE(WQ.YWQXUP.(CUBE000232))
rz2ind PACKAGE(WQ.YWQXUP.(CUBE000239))
rz2ind PACKAGE(WQ.YWQXUP.(CUBE000247))
.CONNECT DBOF
--#SET TERMINATOR ;
SET CURRENT SQLID = 'S100447';
CREATE STOGROUP "GSMS "
VOLUMES
("* "
)
VCAT DBOF;
SET CURRENT SQLID = 'S100447';
CREATE DATABASE WQ01A1P
BUFFERPOOL BP2
INDEXBP BP1
STOGROUP "GSMS "
CCSID EBCDIC;
SET CURRENT SQLID = 'S100447';
CREATE TABLESPACE AX14A
IN WQ01A1P
USING STOGROUP "GSMS "
PRIQTY -1
SECQTY -1
ERASE NO
BUFFERPOOL BP2
CLOSE YES
LOCKMAX SYSTEM
SEGSIZE 64
FREEPAGE 0
PCTFREE 10
GBPCACHE CHANGED
DEFINE YES
LOGGED
TRACKMOD YES
COMPRESS YES
LOCKSIZE ROW
MAXROWS 255
CCSID EBCDIC;
SET CURRENT SQLID = 'S100447';
CREATE TABLE OA1P.TWQX14A1
(FM_UUID CHARACTER(16) FOR SBCS DATA
NOT NULL
,FM_CREATE_TS TIMESTAMP (6) WITHOUT TIME ZONE
NOT NULL
,FM_CREATE_PID CHARACTER(8) FOR SBCS DATA
NOT NULL
,FM_FAX_TEMPLATE_ID CHARACTER(3) FOR SBCS DATA
NOT NULL
,FM_FO_UUID CHARACTER(16) FOR SBCS DATA
NOT NULL
,FM_FRONT_ORDER_NO CHARACTER(18) FOR SBCS DATA
NOT NULL
,FM_PACKAGE_NR INTEGER
NOT NULL
,FM_ACTIVATOR CHARACTER(1) FOR SBCS DATA
NOT NULL
,FM_COM_MEDIUM CHARACTER(1) FOR SBCS DATA
NOT NULL
,FM_FAX_ENTRY_BASIS CHARACTER(24) FOR SBCS DATA
NOT NULL
,FM_REC_CONTACT_NAME CHARACTER(50) FOR SBCS DATA
NOT NULL
,FM_REC_PHONE_NO CHARACTER(25) FOR SBCS DATA
NOT NULL
,FM_REC_FAX_NO CHARACTER(25) FOR SBCS DATA
NOT NULL
,FM_REC_EMAIL CHARACTER(80) FOR SBCS DATA
NOT NULL
,FM_REC_COMMENTS CHARACTER(50) FOR SBCS DATA
NOT NULL
,FM_REMARK VARCHAR(396) FOR SBCS DATA
NOT NULL
,CONSTRAINT CWQX14A1 PRIMARY KEY
(FM_UUID
)
)
IN WQ01A1P.AX14A
APPEND NO
WITH RESTRICT ON DROP
NOT VOLATILE CARDINALITY
DATA CAPTURE CHANGES
AUDIT NONE
CCSID EBCDIC;
SET CURRENT SQLID = 'S100447';
COMMENT ON TABLE OA1P.TWQX14A1
IS 'FaxMessage(FM)';
SET CURRENT SQLID = 'S100447';
COMMENT ON COLUMN OA1P.TWQX14A1.FM_FAX_TEMPLATE_ID
IS 'Fax-Id like in Sectos: (001) DFP - Fax Initial, (002) DFP - Fax 1st
Reminder (003) DFP - Fax 2nd Reminder (004) DFP - Fax Confirmation (005
) DFP - Fax Cancelation (006) RFP - Fax Initial (no Avis from counterpar
ty) (007) RFP - Fax 1st Reminder (no Avis from counterparty) (008) RFP -
Fax 2nd Reminder (no Avis from counterparty) (009) RFP - Fax Confirmati
on (no Avis from counterparty) (010) RFP - Fax Cancel action (no Avis fr
om counterparty) (011) RFP - Fax Initial (based on Avis from counterpart
y) (012) RFP - Fax Confirmation (based on Avis from counterparty)';
SET CURRENT SQLID = 'S100447';
COMMENT ON COLUMN OA1P.TWQX14A1.FM_FRONT_ORDER_NO
IS 'Front-Order number of the front-order. Front order number and pack
age number are together the reference number.';
SET CURRENT SQLID = 'S100447';
COMMENT ON COLUMN OA1P.TWQX14A1.FM_PACKAGE_NR
IS 'The package number of the fax message per front order.';
SET CURRENT SQLID = 'S100447';
COMMENT ON COLUMN OA1P.TWQX14A1.FM_ACTIVATOR
IS 'Activation of the fax generation. Automatic(A) or manual(M).';
SET CURRENT SQLID = 'S100447';
COMMENT ON COLUMN OA1P.TWQX14A1.FM_COM_MEDIUM
IS 'Communication medium. E-Mail(E) or Fax(F).';
SET CURRENT SQLID = 'S100447';
COMMENT ON COLUMN OA1P.TWQX14A1.FM_FAX_ENTRY_BASIS
IS 'Fax Erfassungs-Grundlage.';
SET CURRENT SQLID = 'S100447';
COMMENT ON COLUMN OA1P.TWQX14A1.FM_REC_CONTACT_NAME
IS 'Recipient conact name';
SET CURRENT SQLID = 'S100447';
COMMENT ON COLUMN OA1P.TWQX14A1.FM_REC_PHONE_NO
IS 'Recipient phone number';
SET CURRENT SQLID = 'S100447';
COMMENT ON COLUMN OA1P.TWQX14A1.FM_REC_FAX_NO
IS 'Recipient fax number';
SET CURRENT SQLID = 'S100447';
COMMENT ON COLUMN OA1P.TWQX14A1.FM_REC_EMAIL
IS 'Recipient e-mail address.';
SET CURRENT SQLID = 'S100447';
COMMENT ON COLUMN OA1P.TWQX14A1.FM_REC_COMMENTS
IS 'Recipients comments.';
SET CURRENT SQLID = 'S100447';
COMMENT ON COLUMN OA1P.TWQX14A1.FM_REMARK
IS 'Freetext for writing remarks. 6 X 66 (VARCHAR 396)';
SET CURRENT SQLID = 'S100447';
CREATE TABLESPACE AX13A
IN WQ01A1P
USING STOGROUP "GSMS "
PRIQTY -1
SECQTY -1
ERASE NO
BUFFERPOOL BP2
CLOSE YES
LOCKMAX SYSTEM
SEGSIZE 64
FREEPAGE 0
PCTFREE 10
GBPCACHE CHANGED
DEFINE YES
LOGGED
TRACKMOD YES
COMPRESS YES
LOCKSIZE ROW
MAXROWS 255
CCSID EBCDIC;
SET CURRENT SQLID = 'S100447';
CREATE TABLE OA1P.TWQX13A1
(MS_UUID CHARACTER(16) FOR SBCS DATA
NOT NULL
,MS_CREATE_TS TIMESTAMP (6) WITHOUT TIME ZONE
NOT NULL
,MS_CREATE_PID CHARACTER(8) FOR SBCS DATA
NOT NULL
,MS_UPDATE_TS TIMESTAMP (6) WITHOUT TIME ZONE
NOT NULL
,MS_UPDATE_PID CHARACTER(8) FOR SBCS DATA
NOT NULL
,MS_FK_MO_UUID CHARACTER(16) FOR SBCS DATA
NOT NULL
,MS_FK_FM_UUID CHARACTER(16) FOR SBCS DATA
WITH DEFAULT NULL
,MS_FAX_STATE CHARACTER(3) FOR SBCS DATA
NOT NULL
,MS_STATUS SMALLINT
NOT NULL
,CONSTRAINT CWQX13A1 PRIMARY KEY
(MS_UUID
)
)
IN WQ01A1P.AX13A
APPEND NO
WITH RESTRICT ON DROP
NOT VOLATILE CARDINALITY
DATA CAPTURE CHANGES
AUDIT NONE
CCSID EBCDIC;
SET CURRENT SQLID = 'S100447';
COMMENT ON TABLE OA1P.TWQX13A1
IS 'MovementFaxState(FS)';
SET CURRENT SQLID = 'S100447';
COMMENT ON COLUMN OA1P.TWQX13A1.MS_UUID
IS 'PK';
SET CURRENT SQLID = 'S100447';
COMMENT ON COLUMN OA1P.TWQX13A1.MS_FK_MO_UUID
IS 'FK';
SET CURRENT SQLID = 'S100447';
COMMENT ON COLUMN OA1P.TWQX13A1.MS_FK_FM_UUID
IS 'FK';
SET CURRENT SQLID = 'S100447';
COMMENT ON COLUMN OA1P.TWQX13A1.MS_FAX_STATE
IS 'Movement-Fax-States: 1: Initial Fax sent 2: 1st Reminder due 3:
1st Reminder sent 4: 2nd Reminder due 5: 2nd Reminder sent 6: ...';
SET CURRENT SQLID = 'S100447';
COMMENT ON COLUMN OA1P.TWQX13A1.MS_STATUS
IS 'Status if the Movement-Fax-Message is ''active'' or ''inactive''
. 0 = inactive; 1 = active;';
SET CURRENT SQLID = 'S100447';
CREATE INDEX OA1P.IWQX13A002
ON OA1P.TWQX13A1
(MS_CREATE_TS 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;
SET CURRENT SQLID = 'S100447';
CREATE INDEX OA1P.IWQX13A003
ON OA1P.TWQX13A1
(MS_FAX_STATE 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;
SET CURRENT SQLID = 'S100447';
CREATE INDEX OA1P.IWQX13A004
ON OA1P.TWQX13A1
(MS_STATUS 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;
SET CURRENT SQLID = 'S100447';
CREATE UNIQUE INDEX OA1P.IWQX13A001
ON OA1P.TWQX13A1
(MS_UUID 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;
SET CURRENT SQLID = 'S100447';
CREATE UNIQUE INDEX OA1P.IWQX14A001
ON OA1P.TWQX14A1
(FM_UUID 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;
SET CURRENT SQLID = 'S100447';
ALTER TABLE OA1P.TWQX13A1
ADD
CONSTRAINT CWQX13A3
FOREIGN KEY
(MS_FK_FM_UUID
)
REFERENCES OA1P.TWQX14A1
(FM_UUID
) ON DELETE RESTRICT
ENFORCED;
-- generating rebinds in DE0G at 11:18:47 22/07/14 for A540769
-- for 2 tablespace, 2 table, 0 view, 6 index, 0 alias, 0 synonym
-- tablespace WQ01A1P.AX14A
-- tablespace WQ01A1P.AX13A
-- table OA1P.TWQX13A1
-- table OA1P.TWQX14A1
-- index OA1P.IWQX13A005
-- index OA1P.IWQX13A002
-- index OA1P.IWQX13A003
-- index OA1P.IWQX13A004
-- index OA1P.IWQX13A001
-- index OA1P.IWQX14A001