RE: User Space or Data Queue or PF or IFS

[qsrvbas@xxxxxxxxxxxx (Tom Liotta)]

rpg400-l-request@xxxxxxxxxxxx wrote:

>   3. RE: User Space or Data Queue or PF  or IFS (John Brandt Sr.)
>
>Andy,
>That would be great. The only problem is that this
>data is being sent by an SQL server in a pure stream
>format with no End of Record and no End of File markers.
>John

Okay, John, then can you give a picture of how any program on an iSeries can 
actually _use_ this data? If I use the SQL CLI to retrieve rows from another 
iSeries DB2 table, I can fairly cleanly handle records/rows. But it doesn't 
sound as if I could simply substitute SQL Server as my remote point and use 
even approximately similar program code.

If you aren't somehow detecting end-of-record/end-of-file as middleware, how 
should it be done?

And if you can't predict nor control how large the result set will be, why not 
just CRTPF RCDLEN(32766) and use simple sequential processing for your storage? 
Perhaps allow a toggle setting -- create a *usrspc for small data sets and a PF 
for unlimited size? Let the user decide which to use.

Tom Liotta

-- 
Tom Liotta
The PowerTech Group, Inc.
19426 68th Avenue South
Kent, WA 98032
Phone  253-872-7788 x313
Fax    253-872-7904
http://www.powertech.com


__________________________________________________________________
McAfee VirusScan Online from the Netscape Network.
Comprehensive protection for your entire computer. Get your free trial today!
http://channels.netscape.com/ns/computing/mcafee/index.jsp?promo=393397

Get AOL Instant Messenger 5.1 free of charge.  Download Now!
http://aim.aol.com/aimnew/Aim/register.adp?promo=380455