|
Oops - I looked closer in that RRN and there IS a numeric fieldcontaining blanks.
"bad data" ?
Is it possible to have SQL ignore this problem and copy the row with the
mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Stone, Joel
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [
Sent: Tuesday, January 15, 2013 9:43 AMerror.
To: midrange-l@xxxxxxxxxxxx
Subject: SQL help - Data base conversion mapping error. 0 fields in
askew.
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
09:33:57
Thanks
Additional Message Information
Message ID . . . . . . : MCH1801
Date sent . . . . . . : 13/01/15 Time sent . . . . . . :
error.
Message . . . . : Data base conversion mapping error. 0 fields in
is
Cause . . . . . : The data space number is 1. Ordinal entry number
7348969, and the incorrect fields areX'80000008000000000000103C00010001007022E90000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000'.09:33:57
Next msg in job log:
Additional Message Information
Message ID . . . . . . : CPF2479
Date sent . . . . . . : 13/01/15 Time sent . . . . . . :
call
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
stack.specified
Recovery . . . : Change the call stack entry name or be sure the
entry is in the call stack when doing the requested operation.09:33:58
Next msg:
Additional Message Information
Message ID . . . . . . : CPF5035
Date sent . . . . . . : 13/01/15 Time sent . . . . . . :
in
Message . . . . : Data mapping error on member *QUERY0001.
Cause . . . . . : A data mapping error occurred on field C010040052
record number 0, record format *QUERYHASH, member number 1, inmember
*QUERY0001 file *QUERY0001 in library QTEMP, because of error code20. The
error codes and their meanings follow:value.
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
4 -- A floating point value was less than the minimumrepresentable value.
5 -- A floating point value that is not a number could not bemapped from
double to single precision or from single to double.zoned
6 -- A floating point value could not be mapped to packed decimal,
Skyscan service.
______________________________________________________________________
This outbound email has been scanned for all viruses by the MessageLabs
For more information please visit http://www.symanteccloud.com/
______________________________________________________________________
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.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 on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.