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

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 <luis.rodriguez2@xxxxxxxxx> 

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