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

Ersan

Allow me also to welcome you.

As in all other database systems, there are system catalogs on the iSeries. The persons telling you otherwise may not have known this. If you are on a terminal session, you can see the names by running this command -

WRKF SYS*

You will see things that probably look quite familiar.The links and commands others gave you will get you started.

Regards
Vern

Ersan Ercek wrote:

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/