IBM i Global

IBM i 

A space for professionals working with IBM’s integrated OS for Power systems to exchange ideas, ask questions, and share expertise on topics like RPG and COBOL development, application modernization, open source integration, system administration, and business continuity.


#Power


#IBMi
#Power
 View Only

  • 1.  Spool File too Wide [350 columns]

    Posted 24 days ago

    Hello and Happy new year to you all, 

    I need to produce a report [spool file] that has over 350 characters wide. That is my 1st goal.
    My 2nd goal is to convert the spool into a PDF & e-Mail to an US Government Agency.
    I got a 3rd party tool [SpoolFlex from DRV Tech] that will a spool & convert to PDF hence i may be OK & no problem on the 2nd goal.
    But I cannot get thru my 1st goal namely the DDS does not allow to print anything beyond 255 characters width. 
    Here are the 2 messages I get:
    * CPD7807      10        2      Message . . . . :   Length and position values cause fields to overlap.
    * CPD7874      30        1      Message . . . . :   Line or position value greater than 255.
    So, I do not have a way to produce a spool file far wider than 255 Chars. 
    This is USDA which is a bureaucratic government Agency hence they are not accepting a CSV from us. 
    Is there a tool that will take a Physical File or a CSV from IFS Directory & turn it into Spool file ?
    OR
    Is there a tool that will take a Physical File or a CSV from IFS Directory & turn it into PDF ?
    OR
    Is there an other option ?


    ------------------------------
    Mohan Eashver
    ------------------------------


  • 2.  RE: Spool File too Wide [350 columns]

    Posted 24 days ago
    Edited by Satid S 24 days ago

    Dear Mohan

    Why not run SQL queries from a Windows/Linux PC (for example from within an Excel spreadsheet over ODBC) to physical files in IBM i and save the results in the PC and convert them to a PDF file?  I guess it should be easier to circumvent 255-character limit of IBM i spools file.  



    ------------------------------
    Satid S
    ------------------------------

    Original Message


  • 3.  RE: Spool File too Wide [350 columns]

    Posted 23 days ago

    Not sure why you believe a printer file is limited to 255 character lines. CRTPRTF allows this 

    so it appears to me that the max width is 378 characters and max length is 255 lines.



    ------------------------------
    John Sherrill
    ------------------------------

    Original Message


Related Content