RE: Calling a DB procedure from another DB

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
 

> -----Original Message-----
> From: midrange-l-bounces+cwilt=meaa.mea.com@xxxxxxxxxxxx
> [mailto:midrange-l-bounces+cwilt=meaa.mea.com@xxxxxxxxxxxx]On 
> Behalf Of
> R Bruce Hoffman
> Sent: Friday, May 13, 2005 8:16 AM
> To: Midrange Systems Technical Discussion
> Subject: Re: Calling a DB procedure from another DB
> 
> 
> On Fri, 2005-05-13 at 01:13, ali.juzer@xxxxxxxxx wrote:
> > We have two databases - Oracle 8i running on a Windows 2K 
> machine and
> > DB2/400 running on a AS/400 machine. There is an ODBC 
> connection between
> > these two databases. We use SQL commands in Oracle to access DB2/400
> > files.
> 
> > Our requirement is to call a Cobol program residing in AS/400 from
> > Oracle. Is this possible? Can anyone help me with some code 
> snippets?
> 
> Nothing unique about the COBOL program. Just use the SQL 'create
> procedure' statement to make it a stored procedure on the 400. Then a
> standard SQL CALL can get at it.
> 
> 
> -- 
> "Bigamy is having one wife too many. Monogamy is the same."
> -- Oscar Wilde
> 
> -- 
> This is the Midrange Systems Technical Discussion 
> (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
> 
>