Re: Find files in any library -- MIDRANGE-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

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

This mailing list archive is Copyright 1997-2024 by midrange.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 on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.