Re: Fastest string scan

[Denis Robitaille <drobitaille@xxxxxxxxxxxx>]

Joe Teff wrote:
> 
> Creating and index file of all words will work, though check for duplicate 
>entries if you do
it that way (the same "word" can appear in the same record more than
once). You do not have to
leave the RPG to do the OPNQRYF either. Just code your OVRDBF, OPNQRYF,
CLOF and DLTOVR
commands in the RPG and execute them with QEXCCMD. With the new syntax
of RPG/ILE, building
OPNQRYF commands has never been easier. Using an index file will perform
best regardless of
the size of the file, but uses disk to store the indexes and requires
that you keep it
up-to-date (sounds like a good use for a trigger). The OPNQRYF command
takes time to complete
but does not require additional "index" space and update pgm.

> 
> Joe Teff
> QDS
> Bloomington, MN
Thanks again, i didnt tought of QCMDEXEC. The idea of the trigger
program is also very tempting.
-- 
Denis Robitaille
Cascades Inc.
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to "MIDRANGE-L@midrange.com".
| To unsubscribe from this list send email to MAJORDOMO@midrange.com
|    and specify 'unsubscribe MIDRANGE-L' in the body of your message.
| Questions should be directed to the list owner/operator: david@midrange.com
+---