Command to list all Databases (Files and Fields W/Type,Size..etc) on AS400?

I was looking around and was wondering if there is a command or any way to get a list of all Files database Files W/Fields size, type, desc....etc. A creating of a file is prefered but a splf would also be fine. Any info is appreciated :)

                                                  Thanks in advance
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

there is a dspffd command that showes fields in a file. There are some utilities out there that put it into a nice format.
another way is using the system maintained QADBIFLD file.
This has all the files, fields etc..

You can write a simple query to show the details you want.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
pugmi16Author Commented:
Perfect!! Thats exactly what I was looking for as I am building a data Model/Dictionary and needed Files with Fields...etc Thanks
Technically, files such as QADBIFLD shouldn't be directly accessed. Rather, the info should be gathered out of the views that are built over them such as QSYS2/SYSCOLUMNS.

Because QADBIFLD is a physical table maintained by (and technically for) DB2/400, direct access can potentially establish record or member locks that interfere with normal behind-the-scenes database maintenance. IBM supplies various LFs and SQL VIEWs for customer use.

The risk is small and probably getting smaller as each release of OS/400 comes out. But a missing PTF can be enough to result in trouble in the database indices, sometimes requiring RCLSTG *DBXREF to clean up.

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
IBM System i

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.