Re: CPF5035 Data mapping error

[CRPence <CRPbottle@xxxxxxxxx>]

 The CPF5035 is a generic error for a variety of conditions whereby 
the database can not determine a valid & understandable value 
from\for a column or expression.  The OP of this thread was 
presumably getting the error for having assigned character data into 
the length portion of a varchar which is -802 rc11.  In the prior 
topic\thread about a sqlcode 22023 there is apparently character 
data in numeric [host] variables which is sql0802 rc6.  Similar yet 
entirely different, and of entirely different origins.

  BTW, please do not post the entire digest to reply.  Thanks.

Regards, Chuck

DLee@xxxxxxxx wrote:
> Glad to hear someone else is having this same problem I was.
> Mine turned out to be invalid data in a field I wasn't even
> referencing in  the embedded sql program.
> Too bad there isn't a way to ignore fields we don't need.
>
> The invalid data on these records has been in existence
> since 2003, and not causing any problems that I know of.
> Until I tried to process the file with SQL this week.
>
> At firs I thought it was just crappy test data until I looked
> in the production files.
>
> I ended up fixing all the data before I could get the program
> to run to end of job.