Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003
    Posts
    50

    Exclamation Unanswered: Update table on Oracle from DB2 database

    Hi,

    I need to know what is the easiest way to update an oracle table from db2 database. If i was updating a db2 table from oracle, then i could use gateways in oracle. Is there something similar in DB2.

    Ideally i would liek to be able to call an oracle stored procedure from a db2 stored procedure. I don't know if this is possible.

    Thanks,
    Dave

  2. #2
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513
    Quote Originally Posted by ddempsey
    Hi,

    I need to know what is the easiest way to update an oracle table from db2 database. If i was updating a db2 table from oracle, then i could use gateways in oracle. Is there something similar in DB2.

    Ideally i would liek to be able to call an oracle stored procedure from a db2 stored procedure. I don't know if this is possible.

    Thanks,
    Dave
    I suspect you're looking for federated database support. (Formerly DataJoiner)
    --
    Jonathan Petruk
    DB2 Database Consultant

Posting Permissions

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