Re: Oracle 12 <-> DB2

That is true. However, it is possible to create AFTER INSER triggers on DB2 tables which can call stored procedures. It is also possible to schedule scripts which will call stored procedures using crontab, anacron or any other scheduler.

On 06/09/2017 09:29 AM, Reen, Elizabeth (Redacted sender elizabeth.reen for DMARC) wrote:
>
> Golden Gate just moves data. It doesn’t run any code.
>
> Liz
>
> Elizabeth Reen
> CPB Database GroupManager
> 718.248.9930 (Office)
>
> Service Now Group: CPB-ORACLE-DB-SUPPORT
>
> *From:*oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] *On Behalf Of *Rob Lockard
> *Sent:* Thursday, June 08, 2017 5:15 PM
> *To:* oracle-l_at_freelists.org
> *Subject:* Re: Oracle 12 <-> DB2
>
> Will Golden Gate call stored procedures on DB2? We have a lot of
> PL/SQL packages in Oracle that are calling stored procedures on DB2.
>
> On 6/8/2017 5:08 PM, Andrew Kerber wrote:
>
> Golden Gate will work with DB2
>
> Sent from my iPhone
>
>
> On Jun 8, 2017, at 12:37 PM, Stefan Knecht
> <knecht.stefan_at_gmail.com <mailto:knecht.stefan_at_gmail.com>> wrote:
>
> Oracle Gateway can connect to DB2:
>
> http://www.oracle.com/technetwork/database/gateways/index.html
> <https://urldefense.proofpoint.com/v2/url?u=http-3A__www.oracle.com_technetwork_database_gateways_index.html&d=DwMCaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=yWMFosURAngbt8VLeJtKLVJGefQxustAZ9UxecV7xpc&m=agzoAVEgvCtD6mNtxJsEUeTMnu0qFop7XwgEvsEw7m0&s=ApfmAYG36JWAlYtFdxAzAmPE8vi_wwS1dvjlGNg1-Yw&e=>
>
> On Fri, Jun 9, 2017 at 12:30 AM, rob oraclewizard.com
> <https://urldefense.proofpoint.com/v2/url?u=http-3A__oraclewizard.com&d=DwMCaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=yWMFosURAngbt8VLeJtKLVJGefQxustAZ9UxecV7xpc&m=agzoAVEgvCtD6mNtxJsEUeTMnu0qFop7XwgEvsEw7m0&s=6-KsFlDrmfNjJ-qKtPAmCyoZJve_xgDZ3dvPAyoBNP0&e=>
> <rob_at_oraclewizard.com <mailto:rob_at_oraclewizard.com>> wrote:
>
> Does anyone know of a product that will give bi-directional
> communications from Oracle 12.2 to DB2 on System-Z. Oracle is
> calling a DB2 stored procedure that returns results. Right now
> we are using Start Quest to do this, The shop is upgrading
> from Oracle 10g -> 12.2, and can not get the Star Quest
> product to work. Thanks -Rob
>
>
>
> --
> ================================
> "The question isn't who is going to let me; it's who is going to stop me."
> Ayn Rand
> Robert P. Lockard
> www.oraclewizard.com
> <https://urldefense.proofpoint.com/v2/url?u=http-3A__www.oraclewizard.com&d=DwMCaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=yWMFosURAngbt8VLeJtKLVJGefQxustAZ9UxecV7xpc&m=agzoAVEgvCtD6mNtxJsEUeTMnu0qFop7XwgEvsEw7m0&s=7_PS27XbhdcbTkPmMkdZxC-AvaXsdFLE-PxbIDSUcwA&e=>
> (c) 571.276.4790
> Twitter: _at_YourNavionPilot

-- 
Mladen Gogala
Oracle DBA
Tel: (347) 321-1217


--
http://www.freelists.org/webpage/oracle-l