Re: Pass ResultSet / Array of Strings from Java to AS400 Stored Procedure

Hi
I have never tried passing resultset as input
parameter to a stored procedure in RPG ( I guess this
is what you are trying)
but what i normally pass is String object to stored
procedure, 
if you are planning to call java from RPG in your
stored procedure then may be you can try it, 

Ashish
--- Szabolcs Pall <spall@xxxxxxxxxxxxxxx> wrote:
> Hi,
> 
> I have some data in Oracle that I retrieve using
> JDBC, and then want to 
> step through the resultset, updating an AS400
> Physical File. The resultset 
> has about 10,000 records... so Statement and
> PreparedStatement are way too 
> slow.
> 
> I want to use CallableStatement but I don't know how
> to get my resultset 
> to the AS400 stored procedure. Can I pass a Java
> Resultset to an AS400 
> Stored Procedure?
> 
> I've thought about dumping the data from Oracle into
> a data-queue, and 
> then having an RPG program read the data and update
> the file... are there 
> any other workarounds if I can't pass ResultSets to
> prepared statements?
> 
> Thanks,
> Szabolcs
> -- 
> This is the Java Programming on and around the
> iSeries / AS400 (JAVA400-L) mailing list
> To post a message email: JAVA400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit:
> http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the
> archives
> at http://archive.midrange.com/java400-l.
> 
> 


                
__________________________________ 
Do you Yahoo!? 
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/