|
View previous topic :: View next topic
|
| Author |
Message |
banuradha
New User
Joined: 20 Dec 2006
Posts: 19
Location: India
|
|
|
|
Hi ,
Is that possible to call a stored proc by using a trigger ?
can we set off trigger for some time and set it when needed? |
|
| Back to top |
|
 |
mano
New User
Joined: 23 Mar 2006
Posts: 17
Location: chennai
|
|
|
|
Yes we can can call a stored procedure using a trigger
find below trigger statement for calling trigger
CREATE TRIGGER XX.XXYYYYRG
AFTER INSERT ON XX.XX_TRANS_TABLE
REFERENCING NEW AS N
FOR EACH ROW MODE DB2SQL
BEGIN ATOMIC
CALL XX.XX618SP();
END ? |
|
| Back to top |
|
|
|
|
