Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

CPYSPLF - losing Overprint - HELP!

302 views
Skip to first unread message

me

unread,
Apr 10, 2002, 1:16:40 PM4/10/02
to
Hello all,

I am using the CPYSPLF for a very large report that would normally print on
greenbar. I keep getting the message:

"Overprinting lost for records in file PRINT. "

It does copy the file, but with this message. The file that I grab off the
as400 has the last three "columns" of data completely missing. This does
not happen to smaller reports that print on 8.5x11 (at least none that i
have tried so far).

Does anyone have any suggestions on how to correct this?

Thanks in advance!
--
Jonathan Crooks
MIS Manager
PFS Sacramento -==-

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.345 / Virus Database: 193 - Release Date: 4/10/2002


me

unread,
Apr 10, 2002, 1:14:44 PM4/10/02
to

Ugo Gagliardelli

unread,
Apr 10, 2002, 3:43:30 PM4/10/02
to
me wrote:
>
> Hello all,
>
> I am using the CPYSPLF for a very large report that would normally print on
> greenbar. I keep getting the message:
>
> "Overprinting lost for records in file PRINT. "
This means that lines with space 0 (no line feed) were lost, this
happens when underline or hilight were used.

> It does copy the file, but with this message. The file that I grab off the
> as400 has the last three "columns" of data completely missing. This does
> not happen to smaller reports that print on 8.5x11 (at least none that i
> have tried so far).

Maybe the record length of the physical file you're copying to is is
shorter the the record length of the spooled file you're copying from.

> Outgoing mail is certified Virus Free.

Thank you for your attenction, but I'm virus free as I use Netscape,
Lotus Notes and Lotus Smart Suite. :))

--
Dr.Ugo Gagliardelli,Modena,Italy-Certified uindoscrasher-AlcoolInside
Spaccamaroni andate a cagare/Spammers not welcome
Spamers iros a la mierda/Spamers allez vous faire foutre
Spammers loop schijten/Spammers macht Euch vom Acker

me

unread,
Apr 10, 2002, 4:03:46 PM4/10/02
to
> > The file that I grab off the
> > as400 has the last three "columns" of data completely missing. This
does
> > not happen to smaller reports that print on 8.5x11 (at least none that i
> > have tried so far).
---------

> Maybe the record length of the physical file you're copying to is is
> shorter the the record length of the spooled file you're copying from.

Thanks for you help! So how would I go about lengthening the physical file
I created?

---


Outgoing mail is certified Virus Free.

Ugo Gagliardelli

unread,
Apr 10, 2002, 4:05:38 PM4/10/02
to
me wrote:
>
> > > The file that I grab off the
> > > as400 has the last three "columns" of data completely missing. This
> does
> > > not happen to smaller reports that print on 8.5x11 (at least none that i
> > > have tried so far).
> ---------
> > Maybe the record length of the physical file you're copying to is is
> > shorter the the record length of the spooled file you're copying from.
>
> Thanks for you help! So how would I go about lengthening the physical file
> I created?
If it's not a database file you've no chance but creating another file,
otherwise (e.g the file was created by DDS or SQL) jou can change DDS
source and use CHGPF command or use SQL command ALTER TABLE.

Kaj Julius

unread,
Apr 12, 2002, 1:11:13 PM4/12/02
to
Hi,

Seems to me that you are copying the spoolfile without specifying what kind
of control character you want to use (the default value for the CTLCHAR
parameter is *NONE). Using CTLCHAR(*NONE) with a spoolfile that uses
overwriting would result in the message you describe.

The most common CTLCHAR value is, I think, *FCFC. With this value it's very
easy to make a copy of the spoolfile. Just override the printfile (must be a
file with just one field, like QSYSPRT) with the same value (CTLCHAR(*FCFC),
and simply use CPYF to copy the content of your database to the printfile
and you'll have a perfectly identical spoolfile (provided the CPYSPLF works,
wich indicates that the spoolfile doesn't contain too complex information).

Regards,
Kaj

"me" <m...@me.com> skrev i en meddelelse
news:ub8smak...@corp.supernews.com...

0 new messages