RE: Unlimited size result sets

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

Have her open a socket to your RPG server. She makes the request, you shove
the data at her until you don't have any data left to send.

John Brandt
iStudio400.com

-----Original Message-----
From: Buck [mailto:buck.calabro@xxxxxxxxxxxx]
Sent: Thursday, December 18, 2003 9:52 AM
To: rpg400-l@xxxxxxxxxxxx
Subject: Re: Unlimited size result sets


> Get the Java person to make recursive calls to your RPG
> in order to get the dataset(s).

That's the existing situation.  The full scenario is not really an RPG
issue, so I didn't post all the details.  Basically the Java side will be
able to click on a column and sort the dataset in that order.  We RPG folk
want Java to tell us what sort order; we'll return 'one page' of data in
that order.  This means that Java needs to keep track of the last key so she
can ask for page 2, etc.

Her contention is that is is better for us to return the entire dataset to
Java, and let her sort it in whatever order she wants.  Management has
tasked me to find a way to give her the entire quarter of a million record
dataset so she can do a proof of concept.
  --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