Re: Re: Saving multiple source files to a single save

Well, first, because IBM says not to. They say to go through the views in 
QSYS2. The QADB* files are used by the system so much, I guess. And maybe it is 
OK to make other views over these files. So if there are other ways to get the 
same info, I go the other way.

Cheers
Vern
-------------- Original message -------------- 
From: Luis Rodriguez <luis.rodriguez2@xxxxxxxxx> 

May ask why? If you are only reading it, I see no harm 
done... 

But, if you wish, you could copy the data to a temp file 
using CPYF with INCREL or a CREATE TABLE AS... . It will be 
always faster that doing a DSPFD. 

Regards, 

Luis Rodriguez 

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

message: 6 
date: Mon, 20 Nov 2006 16:48:54 +0000 
from: vhamberg@xxxxxxxxxxx 
subject: Re: Saving multiple source files to a single 
savf 

This is good information - thanks. I have one proviso - 
I've never been comfortable with reading the QADBXREF 
directly. 
-------------- Original message -------------- 
From: Luis Rodriguez 

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: 

Luis Rodriguez 

IBM Certified Systems Expert 
eServer i5 iSeries Technical Solutions 



________________________________________________________________________________
 
____ 
Sponsored Link 

Degrees online in as fast as 1 Yr 
MBA, Bachelor's, Master's, Assoc 
http://yahoo.degrees.info 
-- 
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, 
visit: http://lists.midrange.com/mailman/listinfo/midrange-l 
or email: MIDRANGE-L-request@xxxxxxxxxxxx 
Before posting, please take a moment to review the archives 
at http://archive.midrange.com/midrange-l.