Hi,

I am trying to load the data file into one table in db2.

the table have one of the column as amount. the length of that column is 10 digits but in the data file its different, so while loading tha file into the table I have to left pad the amount with 0s.

For example..

the data in the file for amount field is 435 and 2356 then after loading the data into that table the table should have 0000000435, 0000002356

can anyone help me on this?

It is generally a bad idea to store numbers as strings in the database. I suggest you change the column data type to numeric and format the numbers upon selecting from the table.