Data mismatch issue with DB2

[prasson_ibm]

I have simple Job
Seq----> Transformer---->Db2
I have following records in source:-
31,1,1,N,206,2181365126
33,1,1,N,208,2181364446
35,1,1,N,212,2181365113
37,1,1,N,214,2181365076
38,1,1,N,215,2181364745
Sixth col is Integer data type and the file is imported successfully.
But when records are transfered to DB2 table,input records do not matches with source data(6th col records).
I am doing simple transformation in transformer stage.
I dont know what is problem exactly.
Please help me to resolve this issue
Thanks in advance

[ray.wurlod]

The largest signed integer is 2,147,483,647 (2 ^ 31 - 1). Your values are larger that that. You need BigInt or a larger Decimal or Float data type to accommodate these values.

[Mike]

What is the DB2 column data type? Integer? If it is defined as integer, the maximum positive value that a 4-byte integer can hold is 2147483647.

Mike

[prasson_ibm]

Hi Ray,
Thanks for ur solution, issue is resolved.. :D thanks a lot

[ray.wurlod]

Ur was a city in ancient Babylonia. The second person personal pronoun in its possessive form is spelled "your" in English. Please maintain a professional standard of written English on DSXchange.

If the problem is resolved then, as its originator, it's your task to mark the thread as Resolved using the green button at the top.