Print data types in CL program

75 pts.
Tags:
AS/400
CL Program
We have 100 files. We want to print the Field, Field Description and Data types through a CL program. Is it possible in a CL program?
1

Answer Wiki

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

Yes There’s a way. 

If you have all 100 files in the same library. 
You can take DSPFFD result to an out file and do RUNQRY to read from out file and print. 
DSPFFD FILE(LIBRARY/*ALL) OUTFILE(QTEMP/TEMP)
You can create a QRY object to have the report customized to suit your requirement. 
Pradeep.

Discuss This Question: 8  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.
  • ToddN2000
    The best and easiest way is to use the DSPFFD method listed above.
    133,740 pointsBadges:
    report
  • TheRealRaven
    The methods may depend on whether the files are all in a single library or not and whether you want all files in a library or only some of the library's files. Can you give more information?
    35,650 pointsBadges:
    report
  • mahalak
    All the files are in a single library
    75 pointsBadges:
    report
  • mahalak
    I am having one more doubt , Is there any option to print  the Reports in Runqry Command
    75 pointsBadges:
    report
  • mahalak
    Single library means only one  Library i.e  Current Library.
    75 pointsBadges:
    report
  • deepu9321
    Yes. You can use RUNQRY with OUTTYPE(*PRINTER).

    You can create QRY object using WRKQRY for any customization.
    4,980 pointsBadges:
    report
  • mahalak

    yes....We can directly give *printer  Outfile, Know..In Outfile One option is there,i.e print option. Why we go for Runqry...

     

    75 pointsBadges:
    report
  • TheRealRaven
    I wouldn't use WRKQRY at all, and RUNQRY won't create a decent report without WRKQRY. I would use STRQM to create a QM query along with a QM form for reporting. If you are stuck using the old WRKQRY because the SQL tools aren't installed, you might not have a choice though.
    35,650 pointsBadges:
    report

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.

Following

Share this item with your network: