×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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>>
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
