Question

finding source files

AS/400, iSeries development, WRKOBJPDM

I have been given the job of findind all source physical files on out AS400
In the pass there wre no standards for naming them.
Have to locate all of these source physical file on our AS400 and them creat a spreensheet of all menbers trying to locate and drop the duplicate source code.

Any help on how to fine ll of these source file would br helpful

Thanks

Craig

Hey Craig
The file "QADBXREF" contain all files present in your AS400. In that file, there is a field named "DBXTYP" who will contain the type of file D for data file or S for source file.

So...

Be shure that you have proper security priviledge to access the data of this file.

In SQL (STRSQL) ...

SELECT * FROM QSYS/QADBXREF where DBXTYP = 'S'

... and dump it into a work file.

Have Fun!

_________________________
DanTheMan