RE: How to call an AS/400 batch program from an Oracle PL/SQLprocedure

I'm pretty sure Oracle doesn't support this using the "Generic Connectivity" 
Heterogeneous Service, via ODBC or OLEDB.

The original poster would need the Transparent Gateway product ( about $35,000 
USD ) to do this.  

Charles Wilt
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
 

> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Lim Hock-Chai
> Sent: Wednesday, May 04, 2005 9:46 AM
> To: Midrange Systems Technical Discussion
> Subject: RE: How to call an AS/400 batch program from an Oracle
> PL/SQLprocedure
> 
> 
> I think any AS400 program can be called using SQL procedure 
> call.  Another word, you should be able to use JDBC/ODBC to 
> connect to AS400 and use the sql procedure call to exec the program.
> 
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of 
> ali.juzer@xxxxxxxxx
> Sent: Wednesday, May 04, 2005 4:38 AM
> To: MIDRANGE-L@xxxxxxxxxxxx
> Subject: How to call an AS/400 batch program from an Oracle PL/SQL
> procedure
> 
> 
> 
> Hi,
> 
> 
> 
> 
> I want to call an AS/400 batch program (written in cobol) 
> from an Oracle
> PL/SQL procedure. Any ideas?
> 
> 
> 
> 
> Regards,
> 
> 
> 
> 
> 
> Ali Asgar Juzer
> 
> Wipro Technologies, Pune
> 
> 
> Ph.No: 22933700 Extn: 3343
> 
> Cell:91-98230-71361
> 
> 
> 
> 
> 
> 
> 
> 
> Confidentiality Notice
> 
> 
> The information contained in this electronic message and any 
> attachments to this message are intended
> for the exclusive use of the addressee(s) and may contain 
> confidential or privileged information. If
> you are not the intended recipient, please notify the sender 
> at Wipro or Mailadmin@xxxxxxxxx immediately
> and destroy all copies of this message and any attachments.
> -- 
> 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.
> 
> 
> -- 
> 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.
> 
>