catalog question

[rgetgen]

I had this at my previous job, but forget how to do it.

There was a database that contained all of the library/database/field/field descriptions. Unless this was specific to the custom software package, is there a place on any AS400 server to retrieve this?

 

[os400]

This might help.

QADBIFLD lists every field and column on your iSeries.
QADBKFLD lists every key field and column on your iSeries.
QADBXTRIGB lists the triggers on your iSeries. I once published a utility called Trigger Tracker that uses this system catalog.
QAOKP01A lists the users in the System Distribution Directory.
QATMSMTPA contains the email addresses for the users in the System Distribution Directory.

the entire article is here:

http://www.mcpressonline.com/mc/.6b347dbc!more=1#more

Mike Butler
Iseries Guy -> PC's gone, SUNs gone - WooHoo
"Never put off 'til tomorrow what you should have done yesterday