MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » October 2012

Re: Find files in any library



fixed

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





Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact