RE: Quick field scan

[Colin Williams <Williamsc@xxxxxxxxxxxxxxxxx>]

I have done a similar sort of thing using opnqryf. Set up an OPNQRYF
command and use the *CT in the expression

eg

BASEFIELD *CT TESTFIELD

Run the OPNQRYF using QCMDEXC from your RPG program, set the OPNRYF to
only return one or two pages of records at a time,
if you do this you will find that the performance is quite reasonable,
even on large files. 

-----Original Message-----
From: Gerald Magnuson [mailto:magnuson@knapheide.com]
Sent: Monday, July 19, 1999 10: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
+---