RE: User Space or Data Queue or PF or IFS

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

It is a true ODBC driver for the iSeries in native API's.
If the user requests the records, I have to be able to 
retrieve them. 
I think I will use the IFS for anything over 16MB and
just live with the performance hit.


-----Original Message-----
From: Hans Boldt [mailto:boldt@xxxxxxxxxx]
Sent: Monday, November 03, 2003 1:57 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: Re: User Space or Data Queue or PF or IFS


John Brandt Sr. wrote:
> 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?

I've been reading some of the replies, but I'm still confused about 
one thing. It might be worthwhile to step back and consider: What is 
the purpose to these machinations? That is, why not just retrieve 
one record at a time from the SQL server instead of a big bunch of 
records?

Cheers! Hans


_______________________________________________
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