[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now


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

Posted on 2004-10-29
Medium Priority
Last Modified: 2008-02-01
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
Question by:pugmi16
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
LVL 14

Expert Comment

ID: 12445771
there is a dspffd command that showes fields in a file. There are some utilities out there that put it into a nice format.
LVL 14

Accepted Solution

daveslater earned 200 total points
ID: 12445807
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.


Author Comment

ID: 12445962
Perfect!! Thats exactly what I was looking for as I am building a data Model/Dictionary and needed Files with Fields...etc Thanks
LVL 27

Expert Comment

ID: 12528733
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.


Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If something goes wrong with Exchange, your IT resources are in trouble.All Exchange server migration processes are not designed to be identical and though migrating email from on-premises Exchange mailbox to Cloud’s Office 365 is relatively simple…
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

656 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question