I am using DB2 load utility to load DB2 tables(OS/390 v7.1 on mainframe) from flat files(sequential datasets) on mainframe. For some of the fields on flat file corresponding to numeric columns(Decimal(x,y) type) in DB2, I have spaces. The load utility is failing because there are spaces for numeric columns. Can any one suggest a way to filter the spaces or fill the spaces with zeroes, before the load utility is run. Any other solution is also fine.

Thanks in advance for your help.

Srikanth Garimella