DB2 table data insert Issue

naveed.zuber · Post by **naveed.zuber** » Wed Aug 20, 2014 7:15 am

Please provide your suggestions for below issue in DataStage 8.7

Seq File --->Transformations --->DB2 stage

Input:CSV file
5968485627(looks in both sequential file stage and Unix)

Output:DB2 table
Actual: 5?9?6?8?4?8?5?6?2?7(looks in the DB2 connector stage)
Expected: 5968485627

Datatype of both the fields input and output field is same i.e VARCHAR(20)
(Note:Input field is a straight mapping without any transformations)

priyadarshikunal · Post by **priyadarshikunal** » Wed Aug 20, 2014 7:39 am

Did you try looking at that file using any hex editor for any unprintable characters between the numbers and are you using the same character set as the file to read it? Do you have any warning in the job log?