Originally posted by: KYPWTX

Hello Team,

Can I know how to define a trigger for the query in Database Interface Designer ?

I have created a table using DB2 server called Employee.Using that  have generated the type tree in design studio and for that tree I want to trigger through database.But I am unable to do that.,though I have created triggering in DB2  for that employee table using Delete,update,insert queries.

ThankYou.

Originally posted by: Tim Rabbitt

Hello:

WTX does not allow triggering with DB2 databases.  If you review our documentation at http://www-01.ibm.com/support/knowledgecenter/SSVSD8_8.4.1/com.ibm.websphere.dtx.did.doc/references/r_dbidref_Database_Support.htm?lang=en you'll see that WTX database triggering is supported with SQL Server and Oracle.

Regards,

Tim Rabbitt

Originally posted by: paul.brett

It may be possible to define a DB2 trigger to execute an external program (WTX) but this is outside the scope of this forum.

Head on over to the DB2 forum or further assistance on ths topic:  https://www.ibm.com/developerworks/community/forums/html/forum?id=11111111-0000-0000-0000-000000000842

Thank-you

Paul

Follow me on Twitter