View previous topic :: View next topic |
Author |
Message |
dilip Beginner
Joined: 08 Nov 2003 Posts: 7 Topics: 7 Location: india
|
Posted: Mon Nov 17, 2003 10:18 pm Post subject: 'MODE DB2SQL' in DB2 trigger |
|
|
Hi,
What is the significance of specifying 'MODE DB2SQL' in the definition of a trigger ..... For example
CREATE TRIGGER MSSD_UPD
AFTER UPDATE ON MSG_STATUS_DIS
REFERENCING NEW AS N_ROW
FOR EACH ROW MODE DB2SQL
BEGIN ATOMIC
< SQL STMTS >
END
What are the other possible modes? _________________ Dilip T. |
|
Back to top |
|
 |
ofer71 Intermediate
Joined: 12 Feb 2003 Posts: 358 Topics: 4 Location: Israel
|
|
Back to top |
|
 |
|
|