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

Posted on 2004-10-29
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
    LVL 14

    Expert Comment

    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

    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

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

    Expert Comment

    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.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Lean Six Sigma Project Manager Certification

    There are many schools of thought around successful project management, but few as highly regarded as the Six Sigma and Lean methods. With 37 hours of learning, this training will explain concrete processes for increasing efficiency and limiting wasted time and effort.

    Suggested Solutions

    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    Before we dive into the marketing strategies involved with creating an effective homepage, it’s crucial that EE members know what a homepage is. In essence, a homepage is the introductory, or default page, of a website that typically highlights the …
    This video Micro Tutorial is the first in a two-part series that shows how to create and use custom scanning profiles in Nuance's PaperPort 14.5 ( But the ability to create custom scanning profiles al…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    846 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

    Need Help in Real-Time?

    Connect with top rated Experts

    5 Experts available now in Live!

    Get 1:1 Help Now