Unanswered: Problem in populating Numeric columns using DB load
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.