Re: Search OS/400 Physical Files

[CRPence <CRPbottle@xxxxxxxxx>]

  An SQL SELECT query can perform selection of a list of files [and or 
members] from the catalog, and FNDSTRPDM can be called from an SQL 
function by use of SQL CALL via the CL command string API QCMDEXC, 
within that SELECT.  To avoid creating a function, the SQL SELECT query 
can instead be a concatenation of data including the CL command with 
library and file name, to generate a valid FNDSTRPDM invocation that can 
then be inserted into a source member which can be a CLP source member 
to be compiled & run, into a CL batch stream to be submitted, or into a 
REXX source member to be run.  Or SQL in REXX can build a front-end, run 
the SELECT query, and execute the CL.

Regards, Chuck

Shannon ODonnell wrote:
> <<SNIP>>
>
> I did know about the FNDSTRPDM command, but thought that was a pain 
> in the butt way to do this since I didn't want to have to write my 
> own code to search a variable list of files. I mean, I could go that 
> route, but I was really hoping someone already had a freebie utility 
> or other way to do this that did not require so much manual
> intervention.   <<SNIP>>