×

Good News Everybody!

The new search engine is LIVE!

Please report any problems to david (at) midrange.com.




Hi,

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
libraries.


Regards,

Luis Rodriguez


--- midrange-l-request@xxxxxxxxxxxx wrote:



------------------------------

message: 2
date: Fri, 17 Nov 2006 19:51:35 -0600
from: Vernon Hamberg <vhamberg@xxxxxxxxxxx>
subject: Re: Saving multiple source files to a single
savf

Yeah, Al, that's why i suggested dspfd *basatr in another
post - 
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
parameter 
settings have the single-letter column for source or data
type in 
their outfile.

Regards
Vern

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

Al Barsa, Jr.
Barsa Consulting Group, LLC



Luis Rodriguez

IBM Certified Systems Expert
eServer i5 iSeries Technical Solutions


 
____________________________________________________________________________________
Sponsored Link

Compare mortgage rates for today. 
Get up to 5 free quotes. 
Www2.nextag.com

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.