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
Data mismatch issue with DB2
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
Last edited by ray.wurlod on Wed Sep 24, 2008 6:16 am, edited 1 time in total.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
Re: Data mismatch issue with DB2
Hi Ray,
Thanks for ur solution, issue is resolved.. :D thanks a lot
Thanks for ur solution, issue is resolved.. :D thanks a lot
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.