RE: How to Navigate On Database Fields?

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.