View tables and fields

[dbillings]

I'd like to view a tables fields and field types. What are the commands to access the AS/400 system catalog? Are they executable from the command line?

[jamief]

Re: View tables and fields

what exactly are you trying to do?

there is a command to display fields in a specific file
there is an api to list fields in a specific file
there is a table on the iseries with all files/fields listed

jamie

[B.Hauser]

Re: View tables and fields

Hi,

the catalog views are all stored in the QSYS2 library and start with SYS*.
These catalog views can be accessed like any other view, for example with SQL or Query/400 or with a database management tool, if you have one.

Table descriptions can be found in the SYSTABLES view and column descriptions (including field names, data types and lengths) in the SYSCOLUMS view. Also information about all DDS described files can be found in the catalog views.

Birgitta

[BenThurley]

Re: View tables and fields

DSPFFD will show you columns

[bryce4president]

Re: View tables and fields

If you have TAATOOLS you can do a

DSPFMT MYFILE

and to view the logicals you can do

DSPACCPTH MYFILE

That's if you have TAATOOLS...

[dbillings]

Re: View tables and fields

Will any of these show relationships, keys or indexes? If so which ones? Thanks for any help you can offer.

[jamief]

Re: View tables and fields

this one if free and on the index page of this very site.

http://www.code400.com/ffd.php

[kitvb1]

Re: View tables and fields

If you have Infor S21:
DSPFLD will display all the fields
DSPDEP will display all the dependancies
DSPKEY will display the key incl. select/omit and multiformat logicals

[arrow483]

Re: View tables and fields

iSeries Navigator (Database tab) will also give you lots of information

[tomholden]

Re: View tables and fields

DSPFFD - Display File Field Descriptions (COLUMNS)
DSPFD - Display File Description (TABLE/VIEW/INDEX)
DSPDBR - Display Database Relations (VIEWS/INDEXES on TABLES)

[Denny]

Re: View tables and fields

For PRMS users the RMSTD library contains the command DSPRCDLYT (Display Record Layout). This is what they use to generate the documentation of file layouts.

Additionally from the on the menu RMSTD/TD there is a option to maintain user comments at the file or field level. These comments are optionally printed wth DSPRCDLYT. Handy for documenting their obscure code meanings and your modificaitons. Unfortuantely the comment file is shipped empty.