Problem with decimal data

swerajan · Post by **swerajan** » Fri Sep 04, 2009 3:06 am

Hi
The file i am using in the ETL job is created by mainframes. I need to read a data in a particular column as decimal (15,2). The sample data is like 000000006043315. I need the data to be read as 0000000060433.15. But datastage is reading the same as 0000006043315.00 Please provide some valuable inputs for the same.

laknar · Post by **laknar** » Fri Sep 04, 2009 3:25 am

use substring function to extract

Code: Select all

decimalcolumn[1,11]:".":decimalcolumn[12,2]

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Fri Sep 04, 2009 3:26 am

Or divide by 100.

swerajan · Post by **swerajan** » Fri Sep 04, 2009 3:51 am

thanx sainath..

it works

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Fri Sep 04, 2009 3:52 am

Then mark it as resolved.