How to Achieve integer value with out exponential value
Posted: Mon Feb 13, 2006 1:28 pm
Hi,
Can any one help me. I have a stage variable totalpriceval. In properties of stagevariable I mentioned precision as varchar 255 . Iam getting frm source flat file price as char[15] to stage variable . Ex
variable expression
totalprcval If frm_src.recindicator='2' then totalprcval+As integer (frm_src.price) else totalprcval.
I gave in stage variable proprerties
name initalvalue
totalprcval 0 varchar 255
In output Iam getting as 2.72922e+11. I want output as 272922234556 as integer with out exponential . What I have to do to achieve integer value.
Thanks,
Somaraju
Can any one help me. I have a stage variable totalpriceval. In properties of stagevariable I mentioned precision as varchar 255 . Iam getting frm source flat file price as char[15] to stage variable . Ex
variable expression
totalprcval If frm_src.recindicator='2' then totalprcval+As integer (frm_src.price) else totalprcval.
I gave in stage variable proprerties
name initalvalue
totalprcval 0 varchar 255
In output Iam getting as 2.72922e+11. I want output as 272922234556 as integer with out exponential . What I have to do to achieve integer value.
Thanks,
Somaraju