On Thursday, January 26, 2012 at 11:03:07 AM UTC-5, bruno.almeida wrote:

Hello all,

DB2 v9.5 fixpack 5 LUW.

I need insert values on a federated table using a trigger.

Is that possible?

Actually, I´ve got this SQL ERROR on my trigger creation:

SQL30090N Operation invalid for application execution environment.
Reason
code = "22". LINE NUMBER=8. SQLSTATE=25000

Is there another way to do this?

Regards,

Bruno

Read this: https://www.ibm.com/support/knowledgecenter/SSEPGG_9.5.0/com.ibm.swg.im.iis.fed.query.doc/topics/cfpwrktr.html

Clearly say:
You can include SELECT statements on nicknames in the trigger body. You cannot include INSERT, UPDATE, or DELETE statements on nicknames in the trigger body

Sorry!!!

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)