Re: Calling a DB procedure from another DB

["Paul Morgan" <pmorgan@xxxxxxxxxxxxxx>]

Couldn't you set up a new DB2 table/trigger just to call this program?

Have the table defined with all the fields required to call the program
(including any possible returned values) plus some artificial key if you
need to retrieve any returned values.   Write the trigger program to convert
the passed record image into a call to the program.  If the program returns
any values have the trigger program put those values in the record.

To execute the call INSERT a row to the table using ODBC to call the
program.  SELECT that row back from the table using the artificial key if
you need any returned values.

Paul

-- 
Paul Morgan
Senior Programmer Analyst - Retail
J. Jill Group
100 Birch Pond Drive, PO Box 2009
Tilton, NH 03276-2009
Phone: (603) 266-2117
Fax:   (603) 266-2333

Wilt, Charles wrote

> The problem is that the OBDC connection between Oracle and DB2, called
"Generic Connectivity" by Oracle, does _NOT_ support the SQL CALL statement.
>
> To invoke stored procedures on an external database from Oracle, you need
Oracle's Transparent Gateway product; which costs big $$$.
>
>
>
>
>
> Charles Wilt
> iSeries Systems Administrator / Developer
> Mitsubishi Electric Automotive America
> ph: 513-573-4343
> fax: 513-398-1121