System Table for DDMF

[FaStOnE]

Does anyone know the System Table Lib/Name for DDMFs??

I need to identify all DDMFs on our systems and where they point to (System/Library/Table)

Anyone know of a System Table that might have all this in it where I can just run an SQL across and pull it out?

[FaStOnE]

Re: System Table for DDMF

The best I can find at this time is:


SELECT DBXLIB, DBXFIL, DBXLFI RmtFil, DBXLB2 RmtLib
FROM QSYS.QADBXREF
Where DBXATR = 'AR'
and DBXTYP = 'D'
Order by DBXLIB, DBXFIL;

[jamief]

Re: System Table for DDMF

could you use QUSLOBJ to list all the file then use QUSRMBRD to get file descriptions using format MBRD0200 and checking remote file?

[MichaelCatalani]

Re: System Table for DDMF

The quickest route is to do a DSPFD FILE(*ALL/*ALL) FILEATR(*DDMF)

To automate it in a program, you can use the file list api, so that you can filter down on *DDMF file type, and build your info from that.

Edit: I tried Ricks SQL method, and it does work.

[jamief]

Re: System Table for DDMF

Yes I have no DDM files to test with....

[MichaelCatalani]

Re: System Table for DDMF

Yes I have no DDM files to test with....

I created a few on my machine that point back to my machine, just to test with.

[jamief]

Re: System Table for DDMF

You have gobs more energy than I do....

[FaStOnE]

Re: System Table for DDMF

He's not an OLD FART like you are -- with Respect to Tom, everyone KNOWS he's old.

[tomholden]

Re: System Table for DDMF

He's not an OLD FART like you are -- with Respect to Tom, everyone KNOWS he's old.

so says the man 4 years my senior