MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » January 2013

Re: SQL help - Data base conversion mapping error. 0 fields in error.



fixed

Hi Joel

The second-level text for reason 20 is like this -

20 -- A field that is not null capable could not be set to null.

Might be you need a COALESCE or some such function in your SELECT statement. Or there is no matching record in a LEFT OUTER JOIN - seems it is a JOIN that is reporting the problem (QQQJOINI).

HTH
Vern

On 1/15/2013 9:43 AM, Stone, Joel wrote:
Can anyone help with the following error?

This has worked well for a long time. Today it blew.

I looked at RRN 7348969 in the input file and didn't notice anything askew.

Thanks




Additional Message Information

Message ID . . . . . . : MCH1801
Date sent . . . . . . : 13/01/15 Time sent . . . . . . : 09:33:57

Message . . . . : Data base conversion mapping error. 0 fields in error.

Cause . . . . . : The data space number is 1. Ordinal entry number is
7348969, and the incorrect fields are
X'80000008000000000000103C00010001007022E90000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000'.



Next msg in job log:



Additional Message Information

Message ID . . . . . . : CPF2479
Date sent . . . . . . : 13/01/15 Time sent . . . . . . : 09:33:57

Message . . . . : Call stack entry not found.

Cause . . . . . : Call stack entry QQQJOINI, specified for the send,
receive, move or delete message operation, could not be found in the call
stack.
Recovery . . . : Change the call stack entry name or be sure the specified
entry is in the call stack when doing the requested operation.



Next msg:

Additional Message Information

Message ID . . . . . . : CPF5035
Date sent . . . . . . : 13/01/15 Time sent . . . . . . : 09:33:58

Message . . . . : Data mapping error on member *QUERY0001.

Cause . . . . . : A data mapping error occurred on field C010040052 in
record number 0, record format *QUERYHASH, member number 1, in member
*QUERY0001 file *QUERY0001 in library QTEMP, because of error code 20. The
error codes and their meanings follow:
1 -- There is data in a decimal field that is not valid.
2 -- A significant digit was truncated.
3 -- A floating point value exceeded the maximum representable value.
4 -- A floating point value was less than the minimum representable value.
5 -- A floating point value that is not a number could not be mapped from
double to single precision or from single to double.
6 -- A floating point value could not be mapped to packed decimal, zoned

______________________________________________________________________
This outbound email has been scanned for all viruses by the MessageLabs Skyscan service.
For more information please visit http://www.symanteccloud.com
______________________________________________________________________






Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact