RE: User Space or Data Queue or PF or IFS

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

I was considering Data Queues because 
I could probably live with a 2GB limitation.
Most will never ask for a set of data in 
excess of 20 MB, but you never know.
John

-----Original Message-----
From: Chevalier, Rick [mailto:Rick.Chevalier@xxxxxxxxxxxxxxx]
Sent: Monday, November 03, 2003 1:20 PM
To: RPG programming on the AS400 / iSeries
Subject: RE: User Space or Data Queue or PF or IFS


John,

Could you provide a little more information please?  Where is the data
eventually going to reside?  What type of data is being read (comma
delimited, fixed length, ...)?

The data queue option will also have a size limitation (can't remember it
off the cuff) so I'm not sure that will resolve a size issue.  If entries
can be removed as soon as they are placed onto the queue it may not be an
issue.

I'm a little confused about why the record calculation if using a data queue
wouldn't work for other methods also.

Rick

> -----Original Message-----
> From: John Brandt Sr. [mailto:pgmr@xxxxxxxxxxxxxxx]
> Sent: Monday, November 03, 2003 12:20 PM
> To: 'RPG programming on the AS400 / iSeries'
> Subject: User Space or Data Queue or PF or IFS
> 
> 
> I have written a utility to retrieve records from an SQL server.
> I used User Space to store the data returned from the server.
> The problem is that the user space is restricted to 16MB.
> In order to break this limitation, I need to move to another 
> storage method.
> I am putting data directly off a socket in 32K chunks and 
> accessing it by
> address.
> Any method besides the IFS would cause me to have to 
> calculate the record I
> want every I/O, although a Data Queue would work because I 
> can use the 32K
> chunks and just divide my offset by 32767 to get the record 
> that I want. (I
> will still have some overlap, but I can deal with that)
> 
> Any suggestions?
> John Brandt
> iStudio400.com
> 
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.535 / Virus Database: 330 - Release Date: 11/1/03
>  
> _______________________________________________
> 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.
> 

_______________________________________________
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.532 / Virus Database: 326 - Release Date: 10/27/03
 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.535 / Virus Database: 330 - Release Date: 11/1/03