How To Create Triggers

[ks01]

Hello ...

I hope I am posting this question to the correct forum. My organization uses DB2 V7 and BMC Catalog Manager V6.

I would like to create a trigger so when a user runs an insert query on table A, the [tt]ADD_USER_ID[/tt] and [tt]ADD_TIMSTAMP[/tt] fields are updated with the user/current timestamp information. I would also like to create triggers for update and delete queries to update the [tt]LAST_CHG_USER_ID[/tt] and [tt]LAST_CHG_TIMESTAMP[/tt] fields of the same record.

Does anyone know how I can create this or where I can read more about it? I’ve tried reading up on IBM’s DB2 UDB for OS/390 Administration Guide, but I get lost as I’m a novice.

Thanks in advance ...

Kent

 

[blom0344]

There is a redbook on Stored Procedures and Triggers (more than 400 pages ) that you can download as PDF file:

http://www.redbooks.ibm.com/

which probably covers some of the things you want to know

T. Blom
Information analyst
tbl@shimano-eu.com

 

[ks01]

Thank you, I will check it out!

Kent

 

[ks01]

I didn't think to ask, but when I downloaded the PDF, it refers to DB2 UDB for iSeries. We have DB2 V7 which runs on MVS/TSO. Do you know if it's the same?

Thanks ...

Kent