Topic
1 reply Latest Post - ‏2013-05-15T17:49:23Z by PWConner
PWConner
PWConner
42 Posts
ACCEPTED ANSWER

Pinned topic SQL0802 data mapping error based on CPF5029 and CPF5035

‏2013-05-15T13:54:55Z |

I run the following query in Navigator Run SQL scripts:

select rrn( lib.table ), ( #PRIPS - (#FLD05 / dec(1000, 11, 2 ) ) ) * #WSQTP ) from lib.table

I receive plus signs in the column based on the calculation. Record values are:

#PRIPS (dec 15,5) = 89450; #FLD05 (dec 9,2) = 0; #WSQTP (dec 9,2 ) = 39907

Error in the joblog is:

Cause . . . . . :   A data mapping error occurred on member YC80440T file YC80440T in library R72DATPARK, because the data fields in record number 6, record format *FIRST, member number 1 are in error.