RE: How to change the Width of the Spool file?

Hi Siva,

Here is some further information that might help you
to choose a format to meet your requirements.

i5 OS and OS/400 will let you choose any application
format you desire when creating output that might
ultimately be printed. If you choose 10 CPI and 380
columns as the maximum width for a line in your
report, the operating system will determine that your
report is therefore 38 inches wide.

Typically most of IBM's original twinax attached
printers had a maximum carriage width of 13.2 inches
(this is where the system default of 132 columns at 10
CPI comes from). The operating system therefore has
some intelligence in it regarding the capabilites of
target printers. If you were to release the 38 inch
wide spool file mentioned in the previous paragraph to
a printer defined as a 3812 model 1, the system would
realize that the target printer could not support
paper that was 38 inches wide. 

A system message asking whether to truncate or wrap
the information is typically displayed when this type
of problem occurs. In my experience, if you respond to
the message by pressing the enter key you usually get
truncation at 132 columns.

Another issue involves the SCS command that sets the
maximum print position. It happens that the command
uses a single hex byte to specify the MPP in columns
so 255 columns is the largest value supported by the
command. It is typically tied to the use of the CPI
value in a printer file. If you want to use a line
length greater than 255 columns, it is usually a good
idea to specify the horizontal spacing with the
printer file FONT parameter rather than CPI.

In your case, I would suggest considering either Font
281 (20 CPI) or 290 (27 CPI). Personally I find the 27
CPI font to be so small that it is hard for me to read
the text so I usually like to try and stick with the
20 CPI font styles whenever possible.

If you are using Host Print Transform, you can then
specify that one of the input trays in your device
description or remote output queue definition has
either A3 or Ledger paper in it (depends upon where
you are located in the world). Using this larger size
of paper and a printer that supports it, you will be
able to fit your whole line of information on this
size paper in landscape orientation when using a 27
CPI font.

If you use the 20 CPI font, you will only be able to
fit about 335 characters per line so you would need to
follow one of the other poster's suggestions to
specify the column where the query should wrap your
report data.

I hope this information helps you to understand your
page formatting options, in support of your Run Query
generated reports, a little better.

Best Regards,

/Paul

>date: Tue, 22 Mar 2005 12:57:37 -0000
>from: "Emmanuel Zannis" <emmanuel.zannis@xxxxxxxxxxx>
>subject: RE: How to change the Width of the Spool
>file?
>
>Try Dltovr first and then OVRPRTF FILE(QPQUPRFIL)
>PAGESIZE(60 378) LPI(8) CPI(15) 
>
>-----Original Message-----
>From:
>midrange-l-bounces+emmanuel.zannis=hrplc.co.uk@xxxxxxxxxxxx
>[mailto:midrange-l-bounces+emmanuel.zannis=hrplc.co.uk@xxxxxxxxxxxx]On
>Behalf Of AS400 MAILS
>Sent: 22 March 2005 12:50 PM
>To: Midrange Systems Technical Discussion
>Subject: RE: How to change the Width of the Spool
>file?
>
> Yes. I tried this
> 
>OVRPRTF FILE(*PRTF) PAGESIZE(*N 378). But it does not
>make any impact on the spoolfiles created after
>this...
>Hope i am doing the right thing!
>
>Emmanuel Zannis <emmanuel.zannis@xxxxxxxxxxx> wrote:
>Have you tried OVRPRTF. 
>
>-----Original Message-----
>From: midrange-l-bounces@xxxxxxxxxxxx
>[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of
>AS400 MAILS
>Sent: 22 March 2005 12:32 PM
>To: Midrange Systems Technical Discussion
>Subject: Re: How to change the Width of the Spool
>file?
>
>
>Actually I am creating the spool file after issuing
>the RUNQRY command on a Physical file (whuich
contains >more than 30 fields and of 300 bytes record
length) >with OUTTYPE(*PRINTER). So the data after 132
bytes 
>get truncated in the spool file.
>
>Paul Tykodi 
>wrote:
>Hi Siva,
>
>In terms of your question, are you copying an i5 OS -
>OS/400 physical file to a spool file or a PC
formatted
>file (frequently called a stream file) from the IFS
to
>a spool file?
>
>The suggestions regarding how to prevent the
>truncation of the spooled data will be different
>depending upon the format of the file, which is your
>starting point.
>
>Best Regards,
>
>/Paul
>--
>Paul Tykodi
>Principal Consultant
>TCS - Tykodi Consulting Services LLC
>E-mail: ptykodi@xxxxxxxxxx
>
>>date: Mon, 21 Mar 2005 08:59:18 -0800 (PST)
>>from: AS400 MAILS 
>>subject: How to change the Width of the Spool file?
>>
>>Hi
>> 
>>My spool size is 132 bytes. Is there any way to
>>change the width of my spool file so that it will
>>accomadate more data. Because the data gets
truncated
>>when i copy a flat file to a spool file.
>>
>>Anyone can help me in this. Sorry in case if my
>>question sounds dump 
>>:-)...
>> 
>>
>>Thanks
>>Siva.

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com