RE: AS400 return a list?

[<SRamanujan@xxxxxxxxxxxxxxxxxx>]

You could also do a direct SQL call to as/400 database and get the result set 
and load them to a vector and  then work on them.  Due to security reasons and 
record locking issues, it is always recommended to get the data via the Stored 
Proc using Sqlrpg Result sets though.
Thanks,
Sudha

-----Original Message-----
From: rune@kaus.no [mailto:rune@kaus.no]
Sent: Friday, October 11, 2002 12:05 PM
To: java400-l@midrange.com
Subject: Re: AS400 return a list?



It is in fact possible to have the SQLRPG program return an SQL ResultSet
having it defined as an SQL procedure.

Rune



Look at this case:
>From a Java application we ask to an AS400 application the list of houses
than own a person. The answer is a list with one, two,... or eleven...
houses.

Can we work with a return list? What kind of call we should do? Do you have
some recommendations?

Thanks in advance.

Albert Dalmau.

_______________________________________________
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
or email: JAVA400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.






_______________________________________________
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L) 
mailing list
To post a message email: JAVA400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
or email: JAVA400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.