On Wed04-Apr-2011 11:03 , fbocch2595@xxxxxxx wrote:
Did anyone have any issues regarding outfiles and LVLCHK(*YES) for
IBM supplied outfiles? There doesn't seem to be an easy way to report
which files have LVLCHK(*YES) specified.
Assuming [while not suggesting] that all model output files are
physical files in QSYS with the prefix QA [Q for OS, A for database
*FILE type], then the SQL SELECT following the Display File Description
request would produce a report of all model OutFiles having the
attribute of LVLCHK(*YES) [though model output files would typically
have the LVLCHK(*NO)]:
DSPFD FILE(QSYS/QA*) TYPE(*ATR) FILEATR(*PF)
OUTPUT(*OUTFILE) OUTFILE(QTEMP/FDATRPF)
SELECT
PHFILE
, PHLVLC
FROM fdatrpf
WHERE PHLVLC = 'Y'
Of course the above requests can be expanded to include more physical
files. If desirable, the SQL also could be expanded to join that data
to other data with a corresponding record format name and using that to
compare and contrast with a known list of model output file formats for
level identifiers and\or fields\columns and even column attributes.
Regards, Chuck
This mailing list archive is Copyright 1997-2026 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
