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

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

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
> ______________________________________________________________________