Answer Detail: RE: What is the function you would use to transfer a s...

GeekInterview.com > Interview Questions > Data Warehousing > Abinitio

Print |

Question: What is the function you would use to transfer a string into a decimal?

December 12, 2006 04:56:37	#4
mukund	Member Since: Visitor Total Comments: N/A
RE: What is the function you would use to transfer a s...
Hey, use ""reinterpret_as" function to convert string to decimal,or decimal to string. syntax: To convert decimal onto string reinterpret_as(ebcdic string(13),(ebcdic decimal(13))(in.cust_amount)) Cheers, Mukund