i think DspFd (Display File Description) will do this. Press F4 on the field for what type of information.
DSPFD will do it. Use this format:<pre>
DSPFD FILE( mylib/*ALL )
TYPE( *ACCPTH )
OUTPUT( *OUTFILE )
FILEATR( *LF )
OUTFILE( QTEMP/LF )</pre>
That will list all LFs in library “mylib” to a temporary file named LF in QTEMP. (You can use a name other than LF and you can put it in a perm,anent library if you don’t want QTEMP.)
The FILEATR( *LF ) only selects for LFs. The TYPE( *ACCPTH ) only pulls the related access path info from the file descriptions.
After the QTEMP/LF file is built, you can query it to find which LFs are JOIN LFs. The APJOIN column will be ‘Y’ if it’s a join; otherwise it will be ‘N’.