Re: CPF2973 - CPYFRMIMPF -- MIDRANGE-L

Shannon--

See Doug already pointed this out about Paul's answer, sending thisanyway as it has a possible explanation and other examples.

Unless already have, might try doing a similar program run for ' and" as these can sometimes cause strings to terminate early, which isclose enough to truncation that it might generate such a message inparsing, while the program might be able to still transfer it"properly" using the comma delimits.


"15" Pizza"
'Roberto's Pizza'

thx & hth,

--Jerome Hughes


On Aug 9, 2006, at 4:46 PM, Shannon ODonnell wrote:

I wrote a program to do a character count on commas (the delimiterfor thisfile) for one of the failing records and a couple that did not failand

there were the same number of commas.  But that was a good thought.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx

[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Ofpnelson@xxxxxxxxxx

Sent: Wednesday, August 09, 2006 4:29 PM
To: Midrange Systems Technical Discussion
Subject: Re: CPF2973 - CPYFRMIMPF

Have you got any data in the file that could contain commas orquotes ontop of what you would expect as separators? Something like Rob'sfamous

item description:    Pizza, 15"
--

Paul Nelson
Arbor Solutions, Inc.
708-670-6978  Cell
pnelson@xxxxxxxxxx




"Shannon ODonnell" <sodonnell@xxxxxxxxxxxxxxxxxxxxxxxxx>
Sent by: midrange-l-bounces+pnelson=arbsol.com@xxxxxxxxxxxx
08/09/2006 03:23 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
"'Midrange Systems Technical Discussion'" <midrange-l@xxxxxxxxxxxx>
cc

Subject
CPF2973 - CPYFRMIMPF






Hello,



I have a database (PF) that is 788 characters long (one single field).

Stored in it is a CSV file. I use CPYFRMIMPF to copy it to anotherPF,

also
788 characters long, but this one made up of many fields.



Most records from the first file will copy to the second file without

problems. However, about 10% of them copy fine, but kick out theCPF2973 -

Data from file *1 truncated to x-number of characters.

The records that cause this error do not appear to be different inany way

from the ones that do not cause the error.

Neither file has null capable fields and both files are the sameCCSID.




I've found some PTF's for V5R3 that address an potential problem with
CPYFRMIMPF but none appear to be directly related to this particular
problem.

Has anyone else experienced a problem with CPYFRMIMPF on V5R3 suchas Idescribe, or can anyone offer a suggestion of something to try/lookinto?




Thank you,



Shannon O'Donnell

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.


--

This is the Midrange Systems Technical Discussion (MIDRANGE-L)mailing list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.



--

This is the Midrange Systems Technical Discussion (MIDRANGE-L)mailing list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.