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.
Problem with decimal data
Moderators: chulett, rschirm, roy
use substring function to extract
Code: Select all
decimalcolumn[1,11]:".":decimalcolumn[12,2]
Last edited by laknar on Fri Sep 04, 2009 3:26 am, edited 1 time in total.
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom