From System i Navigator
select and expand the tree for a system i Connection
expand the Databases node
select the/a database
expand the Schemas node
(you may need to add the schema/ library you are interested in
by right/clicking Schemas and selecting "Select Schemas to Display")
expand the schema/library you are interested in
click the Tables node under the schema, the right pane
should be populated with a list of tables
right-click the table you are interested in and
select Definition from the right-click menu
a window should open and you should see a tab for Columns
HTH
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Ozgur Isiklar
Sent: Wednesday, July 18, 2012 7:47 AM
To: Midrange Systems Technical Discussion
Subject: How to Navigate On Database Fields?
Hi Friends;
Can you please how I can inquire and know the database columns and field names (together with their real names/synonyms ) in AS/400 ISeries?
Through AS/400 Operations Navigator? or through any other supplemental tools?
*For example*:
*GLPN.....G/L Period Number*
*GLLT......Ledger Type*
*GLDCT........Document Type*
*GLDOC........Document Number*
Maybe it's one of the minor issues for most of you (IBM experts), however a major question for such non-technical persons like me :)
Many thanks in advance...
Best Regards,
Ozgur
--
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.
As an Amazon Associate we earn from qualifying purchases.