Re: How to Navigate On Database Fields?

*Paul ; Gary ;*
**
*Many thanks for your prompt and valuable helps.*
**
*Kind Regards,*
*Ozgur

*
2012/7/18 Gary Thompson <gthompson@xxxxxxxxxxx>

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.



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