How to create iSeries printer file width greater than 378 limit?
Home > IT Answers > AS/400 > How to create iSeries printer file width grea...
Shuete
25 pts.
0
Q:
How to create iSeries printer file width greater than 378 limit?
iSeries, CRTPRTF, Symtrax Compleo, Printer files, iSeries import/export, Microsoft Excel import/export, iSeries printing, AS/400 printing, AS/400 Printer File
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: Jun 26 2009  8:47 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Steveoasdfasdf
625 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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
Last Answered: Jun 29 2009  4:18 PM GMT by Steveoasdfasdf   625 pts.
Latest Contributors: Teandy   3250 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Shuete   25 pts.  |   Jun 29 2009  3:55PM GMT

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.

 

Teandy   3250 pts.  |   Jun 30 2009  1:45PM GMT

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.

 

Shuete   25 pts.  |   Jun 30 2009  2:11PM GMT

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.

 

Steve Pitcher   0 pts.  |   Jun 30 2009  5:19PM GMT

No. That’s the limit.

 

MarkGolden   10 pts.  |   Nov 27 2009  9:23AM GMT

You could have a look at a product call IEXL from Connaught Data Systems.
This allows the creation of files upto the Excel limits.

 
0