RE: User Space or Data Queue or PF or IFS

["Bob cozzi" <cozzi@xxxxxxxxx>]

Of course the other solution is to simply create a 2nd and 3rd User Space as
needed and dump the remaining data there.


Bob Cozzi
Cozzi Consulting
www.rpgiv.com


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Peter Dow
Sent: Monday, November 03, 2003 1:21 PM
To: RPG programming on the AS400 / iSeries
Subject: Re: User Space or Data Queue or PF or IFS

Hi John,

When you say you're accessing the 32K chunks by address, do you mean chunk#
or something?  If you split each chunk into two physical file records,
calculation of the rrn of the chunks would be pretty simple -- rrn1 = chunk#
* 2 - 1, rrn2 = chunk# * 2.  I guess what I'm saying is that calculating the
record you want is not too big a deal.  If speed is an issue, and you think
a multiply would take too long, then try rrn1 = chunk# + chunk# - 1.

hth,
Peter Dow
Dow Software Services, Inc.
909 793-9050 voice
909 793-4480 fax
909 522-3214 cell

----- Original Message ----- 
From: "John Brandt Sr." <pgmr@xxxxxxxxxxxxxxx>
To: "'RPG programming on the AS400 / iSeries'" <rpg400-l@xxxxxxxxxxxx>
Sent: Monday, November 03, 2003 10:19 AM
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.
>
>


---
Outgoing 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/30/2003


_______________________________________________
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.