Loading Integer in Db2 issue

sam334 · Post by **sam334** » Wed Apr 09, 2014 7:33 am

Hi, Need a help on loading four digit code number from SQL to DB2 database. In input SQL db the code column data type is (Varchar,4) and output db2 database it is Integer.

The issue is that, in SQL db if an number is 0837, in output DB2 its loading as 837. Its a straight column mapping.

Thanks.

anbu · Post by **anbu** » Wed Apr 09, 2014 7:46 am

Leading zeroes will be removed from Int columns. If you want to have leading zero, then define it as varchar column in DB2

chulett · Post by **chulett** » Wed Apr 09, 2014 8:03 am

In other words, you have no issue and it is doing exactly what it should be doing. Another alternative is to convert it back to a char when you select it from the DB2 table if that leading zero is needed / significant.

sam334 · Post by **sam334** » Wed Apr 09, 2014 8:11 am

Thanks a lot. I changed it.. working fine now....Appreciate your help..