string to integer conversion
Posted: Tue Oct 26, 2010 2:05 am
Hi,
Can any please let me know how to convert string to integer datatype.I know that Datastage implicitly convert the string datatype tp integer datatype without any external function but i'm not getting accurate data in the output.
For example:
I have cust_key(varchar(40) as input and its value 30066293603
and the output is coming as 2147483647 by giving cust_key(integer).
In the source i'm having 11digit value and in the output it is getting as 10digit value.
Please any of you let me know the solution.
Thanks & Regards,
Kalpana.
Can any please let me know how to convert string to integer datatype.I know that Datastage implicitly convert the string datatype tp integer datatype without any external function but i'm not getting accurate data in the output.
For example:
I have cust_key(varchar(40) as input and its value 30066293603
and the output is coming as 2147483647 by giving cust_key(integer).
In the source i'm having 11digit value and in the output it is getting as 10digit value.
Please any of you let me know the solution.
Thanks & Regards,
Kalpana.