RE: Quick field scan

[Greg Behymer <greg.behymer@xxxxxxxxxx>]

Is your file a physical or logical file?  A logical would take a longer
to retrieve than a physical.  I assume a spool file is like a physical
(no key).

> -----Original Message-----
> From: Gerald Magnuson [SMTP:magnuson@knapheide.com]
> Sent: Monday, July 19, 1999 2:11 PM
> To:   MIDRANGE-L@midrange.com
> Subject:      Quick field scan
> 
> I need to provide a method to scan for a character string
> contained anywhere within a field 25 characters long..
> The user wants this to be an INTERACTIVE process.
> 
> the file contains around 75k to 100k records.
> 
> I have a rpg program that uses the scan op code within a do loop.
> 
> I run this program interactivelyand I get my results in about
>  3 minutes (48cpw).  
> I say "Sorry, we are not going to eat up that many cycles for
> this interactivly, we will run this in batch."
> 
> So my user asks:  "Well then, why is it that I can look at a
> report in my outq with all the data (1400 pages) and scan
> and find the data in 30 to 50 seconds, and It takes you 3
> minutes?"
> 
> I know that there is something about spool files that makes
> this type of scanning much faster.
> 
> so the questions are:  
>     Is there a method to perform this type of scan interactivly?
>         (by interactive I mean, to go through 75k records in 30 to
>          50 seconds)
>     
>     What is the reason that the spool file find is so much faster?
> 
> 
> Thank you...
> 
> 
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
> MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
> david@midrange.com
> +---
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---