469,578 Members | 1,471 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,578 developers. It's quick & easy.

displaying message from triggers

hello all,
i have logic like below.
i have to create a trigger which will display a message like "sucessful
insertion" for every row
i insert in to a table".
would any body help me how to do this.

thanks and regards
sridhar

Jul 3 '06 #1
2 1485
situ wrote:
hello all,
i have logic like below.
i have to create a trigger which will display a message like "sucessful
insertion" for every row
i insert in to a table".
would any body help me how to do this.
Display where? User interaction is the job of the app...

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/
Jul 3 '06 #2
Serge Rielau wrote:
situ wrote:
>hello all,
i have logic like below.
i have to create a trigger which will display a message like "sucessful
insertion" for every row
i insert in to a table".
would any body help me how to do this.
Display where? User interaction is the job of the app...

Cheers
Serge
Hi!

Check this out:
http://www-128.ibm.com/developerwork...0302izuha.html

We are using this for stored procedures. MAybe you can try using it also in
triggers.

Best regards,
Kovi
--
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
| Gregor Kovac | Gr**********@mikropis.si |
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| In A World Without Fences Who Needs Gates? |
| Experience Linux. |
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
Jul 4 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

By using this site, you agree to our Privacy Policy and Terms of Use.