This is good information - thanks. I have one proviso - I've never been
comfortable with reading the QADBXREF directly.
-------------- Original message --------------
From: Luis Rodriguez <luis.rodriguez2@xxxxxxxxx>
I've not been following this thread closely, so don't know
if anyone has given the following alternative:
Use the QSYS/QADBXREF file. It contains xref information
for all the files in the system, with attributes such as
kind of file (PF, LF, etc.) and type (Source, data, etc.).
A SQL statement would be:
SELECT DBXFIL, DBXLIB, DBXTXT FROM QADBXREF
WHERE SUBSTR(DBXLIB, 1,1) <> 'Q'
AND DBXATR = 'PF' AND DBXTYP = 'S'
The "Substr(DBXLib"... is for omitting the System
--- midrange-l-request@xxxxxxxxxxxx wrote:
date: Fri, 17 Nov 2006 19:51:35 -0600
from: Vernon Hamberg
subject: Re: Saving multiple source files to a single
Yeah, Al, that's why i suggested dspfd *basatr in another
DSPOBJD has no information as to whether a file is source
or data -
only that it is a PF and maybe PF38 - several DSPFD type
settings have the single-letter column for source or data
At 04:07 PM 11/17/2006, you wrote:
Alternatively, you could do DSPFD *MBRLIST, and that
gives you a one letter
attribution of if it's source or not.
Al Barsa, Jr.
Barsa Consulting Group, LLC
IBM Certified Systems Expert
eServer i5 iSeries Technical Solutions
Compare mortgage rates for today.
Get up to 5 free quotes.
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,
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives