|
Yes... It is a major hit, but I can read through much faster if I'm not actually converting it on the fly, although that is becoming more the answer than the question. John -----Original Message----- From: Anton Gombkötö [mailto:gombkoetoe@xxxxxxxxxx] Sent: Monday, November 03, 2003 3:06 PM To: RPG programming on the AS400 / iSeries Subject: Re: User Space or Data Queue or PF or IFS Hi John, > It was simply due to the ability to fetch > by offset. I was thinking about a PF in QTEMP > with record lengths of 32767. > My only other alternative was multiple user > spaces and just limit the retrieval to 160 meg > or so. > John You wouldn't have to limit the results if you were only "streaming" the data to the application. Data could so eg. pass the line, your program, the users SQLRPGLE program (or?) and then end up on paper. Or been written to disk by the user program, in total or by selection. But the sentence "fetch" implies in me that you are willing to cache the whole thing to be able to wade thru it by means of a cursor. What jumps to mind is what happens when someone creates a cursor and positions it to the end of the file? Would that be a problem/major performance hit? :-) -- Mit freundlichen Grüssen / best regards Anton Gombkötö Organisation und Projektleitung Avenum Technologie GmbH Wien - Salzburg - Stuttgart http://www.avenum.com _______________________________________________ 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
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.