Link to home
Start Free TrialLog in
Avatar of LuckyLucks
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
Avatar of ic3b3rg
ic3b3rg

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?
Avatar of LuckyLucks

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
Avatar of ic3b3rg
ic3b3rg

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial