Re: How to Navigate On Database Fields?

[Ozgur Isiklar <ozgur.isiklar@xxxxxxxxx>]

Dear Rob;

I am grateful for your valuable recommendations.

I will check out and try this query in "Run SQL Scripts" located in AS400
Operations Navigator/Database section.

Many thanks chief :)
Regards,
Ozgur

2012/7/18 <rob@xxxxxxxxx>

> if you have other database experience you should feel at home on the i.
> Have you ever heard of something called SYSCOLUMNS on SQL Server and
> others?  We have that.
> On 5250 you can use STRSQL, in iNav you can try "Run SQL Scripts" located
> in Database to try:
> SELECT
>  /* Big DB2 type names */
> COLUMN_NAME, TABLE_NAME, TABLE_OWNER,
> /* System names */
> SYSTEM_COLUMN_NAME, SYSTEM_TABLE_NAME, SYSTEM_TABLE_SCHEMA
> where ...
> FROM syscolumns;
>
> Or, if you have lots of time and disk to spare you try DSPFFD to an output
> file and query that to get the stuff that you can already get from the
> above query.
>
> Check this out:
>
> http://publib.boulder.ibm.com/infocenter/iseries/v7r1m0/topic/db2/rbafzcatalogtbls.htm
>
>
> Rob Berendt
> --
> IBM Certified System Administrator - IBM i 6.1
> Group Dekko
> Dept 1600
> Mail to:  2505 Dekko Drive
>           Garrett, IN 46738
> Ship to:  Dock 108
>           6928N 400E
>           Kendallville, IN 46755
> http://www.dekko.com
>
>
>
>
>
> From:   Ozgur Isiklar <ozgur.isiklar@xxxxxxxxx>
> To:     Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>,
> Date:   07/18/2012 09:47 AM
> Subject:        How to Navigate On Database Fields?
> Sent by:        midrange-l-bounces@xxxxxxxxxxxx
>
>
>
>  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.