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

Thanks for this warm welcoming.



The thing is I used to work with MS-SQL server and Oracle (Data-Miner) C# (Software devoloper).



When I came here I asked IT department for a favor to provide me with some field names and they told me there is no such table holding the information.



All database systems I worked with hold this information, So I needed expert input.



Thanks to you I am very close to get the information I need.



Thanks alot again.

From: dilbernator@xxxxxxxxx
Date: Tue, 14 Jul 2009 08:15:10 -0600
Subject: Re: How to see libraries, tables and field names.
To: midrange-l@xxxxxxxxxxxx

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.

--
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.

_________________________________________________________________
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.