Trim for Numeric/Decimals

kollurianu · Post by **kollurianu** » Wed Oct 23, 2013 10:10 am

Hi ,

Is it ok to trim the Numeric/Decimal fields from a sequential file and load to Numeric/Decimal fields on target database?

Thanks

IBM Analytics Champion 2009 - 2020 · Post by **asorrell** » Wed Oct 23, 2013 10:44 am

If you are reading the columns as VARCHAR from the sequential file and later converting them to numeric / decimal, then yes - it is ok to trim the VARCHAR field.

If you are reading them in as decimal / numeric, then no Trim is needed, numeric / decimal values do not contain spaces.

kollurianu · Post by **kollurianu** » Fri Oct 25, 2013 9:37 am

Thanks Andy !