Re: Search OS/400 Physical Files

I'll have to go back and find the clp examples of how to use QCLSCAN. I recall
writing clp code years ago to search through file(s) with no problem at all.

After all, it would not be much of an API if you couldn't point to a file.

dsppfm and F16 certainly will find a string in a file but is limited to a single
file. The qclscan and clp could easily handle many files.

I would think sql is a better/quicker choice for what he wants.

The need to scan "many" files is a little unique and I would think
rarely used. Scans are mostly debugging tools for the most part.


vhamberg@xxxxxxxxxxx wrote:

Pat

You can't give this API a file name that I know of - Dave is looking for something to search physical files from a list like one of the PDM things or form WRKF - which has none of this, either.

QCLSCAN is, however, wonderful for searching in variables - and could be used to write a search app for files, it seems.

Regards
Vern

-------------- Original message -------------- From: Pat Barber <mboceanside@xxxxxxxxxxxxxxxx>

From a programming standpoint, here is another way, which has been around since the beginning.
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/apis/qcls can.htm
CRPence wrote:

Shannon ODonnell wrote:

Does anyone know of a utility that will allow you to do a generic search of OS/400 one or more physical files (singly or all at once) for records containing a particular character string?
I'm thinking of something like the Windows Search function which allows you to search for files containing a string within them.
I wonder if one of the unix-type commands I could run in Qshell would have something that would work.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/midrange-l or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.