×
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.
David FOXWELL wrote:
CREATE ALIAS myalias FOR mylib/mysrcfile (mypgm)
SELECT * FROM myalias <<SNIP>>
<<SNIP>> not sure what Date related data structures are.
Adam West wrote:
Any ideas on how to Create utility program to extract the I-spec
of all RPG programs in a source physical file to identify the Date
related data structures? What steps would be needed to do this?
FWiW [only re using SQL]: Since the SQL CREATE ALIAS creates an
object, it is a poor choice for processing all members [even just one
member] of a source physical file; i.e. a new object is created [and
probably since the ALIAS is not desired to remain permanently, it would
then be DROPped immediately thereafter]. Better to perform a runtime
override which redirects the open using nothing more than an entry in an
effective [always present] queue associated with the job. That is, use
OVRDBF MYALIAS TOFILE(MYLIB/MYSRCFILE) MBR(&MLNAME) prior to each SQL
request to SELECT ColumnList FROM MYALIAS, issued for each &MLNAME,
where &MLNAME could come from a DSPFD MYLIB/MYSRCFILE *MBRLIST
OUTPUT(*OUTFILE).
Regards, Chuck
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
