Conversion String to Number
Posted: Tue Dec 05, 2006 7:05 am
Hi
I have some set of records, one of the columns of that recordset having expressions in it that is a varchar columns, Now I want to have result of those expressions e.q.
Say.. particular columns having 10/2 values in it... now I want the end result of this expression i.e. 5
This columns can have multiple expression also like 10/2 + 20 now the end result would be 25.
Can anybody tell me how can i do this, how can i convert this string into proper number format in datastage... I can not use Oracle PL Sql ... I just have to use DataStage only...
waiting for reply
Thanks in advance...
I have some set of records, one of the columns of that recordset having expressions in it that is a varchar columns, Now I want to have result of those expressions e.q.
Say.. particular columns having 10/2 values in it... now I want the end result of this expression i.e. 5
This columns can have multiple expression also like 10/2 + 20 now the end result would be 25.
Can anybody tell me how can i do this, how can i convert this string into proper number format in datastage... I can not use Oracle PL Sql ... I just have to use DataStage only...
waiting for reply
Thanks in advance...