Re: Find files in any library

Define "file". Are we talking Index, View, Table or other stuff like
printer files, etc.

For a table (Physical file)
SELECT SYSTEM_TABLE_SCHEMA FROM qsys2/systables WHERE
SYSTEM_TABLE_NAME ='IIM' ORDER BY system_table_schema

SYSTEM_TABLE_SCHEMA
ERPLXARCF
ERPLXF
ERPLXPRIME
GDIDIVF
GDITOLF
ROBG26
ROBG36
SYSTEMA
TESTRG

Logical files may not show up in any of these three, if they are set up
certain ways. Like this very common logical file:

SELECT SYSTEM_INDEX_SCHEMA FROM
qsys2/sysindexes WHERE SYSTEM_index_NAME ='IIML01' ORDER BY
system_index_schema
no hits

SELECT SYSTEM_view_SCHEMA FROM
qsys2/sysviews WHERE SYSTEM_view_NAME ='IIML01' ORDER BY
system_view_schema
no hits


DSPFD
DSPFD Command Input
File . . . . . . . . . . . . . . . . . . . : FILE IIML01
Library . . . . . . . . . . . . . . . . . : ERPLXF
Type of information . . . . . . . . . . . . : TYPE *ALL
File attributes . . . . . . . . . . . . . . : FILEATR *ALL
System . . . . . . . . . . . . . . . . . . : SYSTEM *LCL
File Description Header
File . . . . . . . . . . . . . . . . . . . : FILE IIML01
Library . . . . . . . . . . . . . . . . . . : ERPLXF
Type of file . . . . . . . . . . . . . . . : Logical
File type . . . . . . . . . . . . . . . . . : FILETYPE *DATA
Auxiliary storage pool ID . . . . . . . . . : 00001
Data Base File Attributes
Externally described file . . . . . . . . . : Yes


Rob Berendt