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

25 pts.
Tags:
AS/400 Printer File
AS/400 printing
CRTPRTF
iSeries
iSeries import/export
iSeries printing
Microsoft Excel import/export
Printer files
Symtrax Compleo
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!
ASKED: June 26, 2009  8:47 PM
UPDATED: November 27, 2009  9:23 AM

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.

http://www.scottklement.com/rpg/ifs_ebook/ch6csv.html

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • 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:
    report
  • 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:
    report
  • 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:
    report
  • Shuete
    No. That's the limit.
    0 pointsBadges:
    report
  • 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:
    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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following