Source for System Supplied Files

2480 pts.
IBM iSeries
Where can I find the source for System Supplied Files? Currently I'm looking for the source for QADSPUPB, which is the outfile for DSPUSRPRF. Thanks, Bill

Answer Wiki

Thanks. We'll let you know when a new response is added.


Go to this site, . It is Craig Rutledge’s site and he has a utility that will create a DDS member of the file. He also has several other useful tools.

I have written an in house utility that will display the file layout of any file on an iSeries showing field name, location, attributes and text. Additionally you can print this out via a function key. It uses DSPFFD outfile for the data but shows it instantly in a readable format. If you would like a copy, free of charge, let me your email address.


Hi Bill,

I don’t believe the source is provided for the system-supplied files. You may be able to find a tool that will retrieve the source for you, or you may be able to re-create the source manually by using DSPFD and DSPFFD to find the field and file definitions.


Martin Gilbert.

Dear Bill,

The List of Columns of ANY file can be retrieved by:

into a database file:
(qgpl/myfile is your choice)

view immediately:


Mordy Gold


The QADSPUPB file format is used when you request *BASIC outfile for DSPUSRPRF. You know this because the <help> for the OUTFILE() parm tells you.

Each command that has OUTFILE() support will use a *FILE object in QSYS that is named in the <help>. There is no “source” but the file field descriptions for each such *FILE is always available by running DSPFFD for the appropriate ‘model’ *FILE.

Generally, you can use CRTDUPOBJ to create a named copy of the ‘model’ before executing the related command. Many (or most) commands don’t require the file to pre-exist and will create the duplicate object automatically. Even for those commands, you might do CRTDUPOBJ yourself in order to set attributes such as maximum size before running the related command.


Discuss This Question: 3  Replies

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Cwc
    There is a system API that will generate SQL/DDL source for a file object, and put it into a source file and member of your choice. It's not DDS, but DDL is supposed to be the modern and more universal method anyway. The name of the API is QSQGNDDL. This can be done through iSeries Navigator as well, and our change management system (ACMS/LMi) also has a menu option for it.
    4,290 pointsBadges:
  • Gilly400
    Hi Cwc, Now that's a handy tip! I have a program somewhere which retrieves DDS from a physical file, but it's very basic. Regards, Martin Gilbert.
    23,730 pointsBadges:
  • wpoulin
    Everyone, Thank You, Bill
    2,480 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.


Share this item with your network: