DSXchange

Hi ,

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

Thanks

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.

Thanks Andy !