RE: Unlimited size result sets

["John Brandt Sr." <pgmr@xxxxxxxxxxxxxxx>]

Get the Java person to make recursive calls to your RPG in order to get the
dataset(s).
John Brandt
iStudio400.com

-----Original Message-----
From: Buck [mailto:buck.calabro@xxxxxxxxxxxx]
Sent: Wednesday, December 17, 2003 4:53 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: Re: Unlimited size result sets


> Can you not return an SQL result set from a stored procedure?

I can't use pure SQL because I need to do some tests/formatting, etc. of the
data before I pass it along to the result set.  But perhaps that is the germ
of my answer... make UDF's in RPG which can be called from pure SQL.  Thanks
John!
  --buck



_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.550 / Virus Database: 342 - Release Date: 12/9/03
 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.552 / Virus Database: 344 - Release Date: 12/15/03