The compare tool in Toad for DB2 5.2, will not detect any differences between two triggers in two identical tables in two different schemas. Toad takes out the SQL body of the trigger DDL, thus making the two triggers look identical.
For example:
After executing the trigger in the Editor, the built script in the Object Explorer truncates the SQL body.
(Executing the following in the Editor):
CREATE TRIGGER TEST1
NO CASCADE BEFORE INSERT
ON TBL1
REFERENCING
NEW AS NEW1
FOR EACH ROW
MODE DB2SQL
WHEN (
(NEW1.TBL1_REVERSAL_TS IS NULL
AND (EXISTS (SELECT * FROM UG95
WHERE NEW1.UG95_COMPANY_CD = UG95_COMPANY_CD
AND NEW1.UG95_COLL_TYPE_CD = UG95_COLL_TYPE_CD
AND NEW1.UG95_CIS_UG_PT_TK = UG95_CIS_UG_PT_TK
AND NEW1.UG95_CHRG_FROM_DT = UG95_CHRG_FROM_DT
AND NEW1.UG95_CHRG_TO_DT = UG95_CHRG_TO_DT
AND NEW1.UG95_DST_RATE_ID = UG95_DST_RATE_ID
AND NEW1.UG95_DST_CMPNT_ID = UG95_DST_CMPNT_ID
AND NEW1.UG95_CMPNT_SEQ_NO = UG95_CMPNT_SEQ_NO
AND NEW1.UG95_CMPNT_STEP_NO = UG95_CMPNT_STEP_NO
AND NEW1.UG95_CMPNT_RATE_ID = UG95_CMPNT_RATE_ID
AND UG95_CHARGE_TP_CD = 'RCUR'
) ) ) )
SIGNAL SQLSTATE '75803'
('INSERT TRIGGER(TBL1BIE)-DUPLICATE RATE/STEP');
(Generated code in Object Explorer):
CREATE OR REPLACE TRIGGER GEORGE1.TEST1
NO CASCADE BEFORE INSERT
ON GEORGE1.TBL1
REFERENCING
NEW AS NEW1
FOR EACH ROW
SIGNAL SQLSTATE '75803'
('INSERT TRIGGER(TBL1BIE)-DUPLICATE RATE/STEP');
é necessário estar conectado e ter um contrato de manutenção atual para visualizar os artigos de conhecimento premium.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center