RE: Passing parameters between Java and CL/COBOL/RPG programs

Jay,

I would love to see this too :)

Terry

> -----Original Message-----
> From: java400-l-bounces@xxxxxxxxxxxx 
> [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Kelly Cookson
> Sent: Wednesday, October 26, 2005 12:37 PM
> To: Java Programming on and around the iSeries / AS400
> Subject: RE: Passing parameters between Java and CL/COBOL/RPG programs
> 
> 
> An example would be great! Thanks!
> Kelly
> 
> -----Original Message-----
> From: java400-l-bounces@xxxxxxxxxxxx
> [mailto:java400-l-bounces@xxxxxxxxxxxx]On Behalf Of Himes, Jay
> Sent: Wednesday, October 26, 2005 11:03 AM
> To: Java Programming on and around the iSeries / AS400
> Subject: RE: Passing parameters between Java and CL/COBOL/RPG programs
> 
> 
> What I have done for cases like this is to create a java program which
> runs in a separate job. I write the SQL statement to be run to a data
> que from the program that needs the information; the java program runs
> the sql statement and writes the row (or rows) to a keyed data que the
> original program is reading from (the key is the original 
> program's job
> indicator so that multiple jobs can use the same que).
> 
> You can avoid the overhead of invoking the program an making a
> connection for every row you whish to retrieve; which can be
> significant.
> 
> If you are interested I can dig up an example.
> 
              <snipped for bandwidth>