Re: How to see libraries, tables and field names.

First, welcome to the lists, and the as/400-iSeries-IBM i world.

What you want depends on the tools you have available. If you have SQL
available to you on i5/os you can run a query against the file QADBIFLD in
library QSYS. It contains the library, file, and field names for all files
on the system. If you are familiar with other SQL compliant database
systems the standard files to query are available as well to get the
information you desire.

Jim

2009/7/14 Ersan Ercek <cinersan@xxxxxxxxxxx>

Dear All,



I am new in this list as well as in AS400.



I was wondering if there is a way to see all library names, table names and
field names.



What I am trying to do is to get all fields from a table including 'OFR' in
table name covered by any library.



Is that possible.



Thank you.

_________________________________________________________________
More than messages–check out the rest of the Windows Live™.
http://www.microsoft.com/windows/windowslive/
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.