Results 1 to 6 of 6
  1. #1
    Join Date
    Jul 2012
    Posts
    2

    Unanswered: After Insert Trigger from Informix to Postgresql

    Good morning.

    I have a big big problem.

    I would like to write an after insert trigger for jnformix.The trigger should insert the data into the PostgreSQL database. The trigger itself should not be the problem. But i dont know if it is even possible to say the trigger in the Informix database use the PostgreSQL database for insert.


    can everybody help me with my problem an show me some programm code?

  2. #2
    Join Date
    Jul 2012
    Posts
    2
    You can create a java or C UDR that insert on the postgresql database, or that execute a REST service that insert on the postgresql database.

  3. #3
    Join Date
    Jul 2012
    Posts
    2
    What is java or c udr? Do you mean a new Programm?

  4. #4
    Join Date
    Jul 2012
    Posts
    2
    UDR(s) are user defined routines. They can be created in C or java, added to informix and executed from a trigger.

  5. #5
    Join Date
    Jun 2009
    Location
    Lisboa, Portugal
    Posts
    78
    Hi,

    Or use IBM Genero

    Kindely,
    LS

  6. #6
    Join Date
    Sep 2011
    Location
    Pont l'Abbé, Brittany, France
    Posts
    381
    Provided Answers: 1
    In this case, use Querix Lycia 2, it is much cheaper than Genero :-)

    I do not see the relationship between a UDR, executed at server level, and something done at application level...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •