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

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

True. Elvis' example shows a way to execute any non-interactive command 
using SQL - the example executes the CALL command via QCMDEXC.

At 09:02 AM 5/4/2005, you wrote:

> I think you can straight call it (I know I'm able to do it on RPG 
> program.).  CALL MYCOBOLPGM().
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Elvis Budimlic
> Sent: Wednesday, May 04, 2005 8:55 AM
> To: 'Midrange Systems Technical Discussion'
> Subject: RE: How to call an AS/400 batch program from an
> OraclePL/SQLprocedure
>
>
> CALL QSYS.QCMDEXC('CALL MYCOBOLPGM', 0000000015.00000);
>
> -----Original Message-----
>  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-----
> 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
>
>
> --
> 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.