Difference Between NUM & IsValid(Decimal'[]') functions
Posted: Wed May 19, 2010 6:57 am
Hello Experts,
My Query seems very silly but I have a little confusion around functions Num & Isvalid(Decimal'[36,18]',stringData).
Isvalid(Decimal'[36,18]',stringData) is not actually Validating the Data coming with Space in it. If incoming Data includes any spaces in it, it will treat it as a valid record but instead Num functions is able to handle all the possiblities of the data.
So can any body suggest what's wrong with the IsValid Function and BTW please differentiate between NUM & ISVALID function.
-- working on:
DS 8.0.1
Sun Solaris 5.10
Thanks in advance.
My Query seems very silly but I have a little confusion around functions Num & Isvalid(Decimal'[36,18]',stringData).
Isvalid(Decimal'[36,18]',stringData) is not actually Validating the Data coming with Space in it. If incoming Data includes any spaces in it, it will treat it as a valid record but instead Num functions is able to handle all the possiblities of the data.
So can any body suggest what's wrong with the IsValid Function and BTW please differentiate between NUM & ISVALID function.
-- working on:
DS 8.0.1
Sun Solaris 5.10
Thanks in advance.