1. Forum
  2. Usenet
  3. COMP.DATABASES.IBM-DB2

  • Trigger insert data through federated table

    From marcocalle87@gmail.com@21:1/5 to bruno.almeida on Thu May 3 16:07:36 2018
    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)