Procedures and Triggers in DB2 Version 6

[aravindkumar]

Hi,
I am using DB2 version 6.0 and finding it difficult to write simple sql stored procedures and triggers. The stored procedure builder only creates java stored procedures. But I want SQL stored procedures. Can anyone send some samples of SQL stored procedures and Triggers. Or some useful links would help..

Thanx in advance
Aravind

 

[soumya]

U can download redbooks from the ibm site.
They are very helpful and there is a particular book for sql procedure itself.

 

[chidi]

As far as I know, DB2 only uses java stored procedures.
I will like to know if indeed there is a sql stored procedure in DB2.
chidi