LuckyLucks
asked on
DB2 datatype corresponding conversion of text
Hi :
I have an a character variable which needs to be converted to the correct numeric format corresponding to DB2 datatypes i.e BigInt, Decimal, Double, Integer, SmallInt, Real.
How can I do this?
Thanks
I have an a character variable which needs to be converted to the correct numeric format corresponding to DB2 datatypes i.e BigInt, Decimal, Double, Integer, SmallInt, Real.
How can I do this?
Thanks
If I understand you correctly, you need to convert the value before you insert/update it into the database. This needs to be done server-side. Which server-side software are you using?
ASKER
no, I need this for making client side comparisions for validation purposes. Now once this validation is positive, then the insertion is made on the server side. I definitely need the conversion on the clientside for these reasons.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.