How to create iSeries printer file width greater than 378 limit?

25 pts.
AS/400 Printer File
AS/400 printing
IBM iSeries
iSeries import/export
Microsoft Excel import/export
Printer files
Is it possible to create an iSeries spooled printer file with a width greater than the 378 character limit on the CRTPRTF command? Possibly using an AFP function? The spooled file is intended to be imported into the COMPLEO utility for conversion to EXCEL. There is no need to print the spooled file. We are on release V5R4M0. Thanks!

Answer Wiki

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

Instead of a spooled file, you can just generate a csv file from RPG and save it to the IFS.

Scott Klement has some great tools for this on his website.

Discuss This Question: 5  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.
  • Shuete
    Thanks but that is not an option. The spooled file must be also be available for native iSeries printing or import to COMPLEO when data selection does not exceed the 378 character width limit. COMPLEO utility then allows creation of EXCEL workbook from standard spooled file.
    25 pointsBadges:
  • Teandy
    You only have a finite number of spaces on a piece of paper. Even with a compression of 20 CPI, I don't think anything over 378 characters will fit. Unless you are printing to a plotter or something else that uses a paper size greater than 11 X 17. Hence the suggestions to create the report as a .CSV or an excel sheet to begin with. You may need two versions of the same report based on data selection. One version will be printed and the other will be output in a different format.
    5,860 pointsBadges:
  • Shuete
    My goal is to optionally override to a spooled printer file that is wider than 378 characters and will NOT be printed. It will be imported into COMPLEO utility and automatically converted to EXCEL (and hence no programming required.) Otherwise, I need to generate a delimited flat file or write directly to EXCEL. So, I am still wondering if there is any way to create an iSeries printer file wider than 378 characters? Thanks.
    25 pointsBadges:
  • Steve Pitcher
    No. That's the limit.
    0 pointsBadges:
  • MarkGolden
    You could have a look at a product call IEXL from Connaught Data Systems. This allows the creation of files upto the Excel limits.
    10 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: