What does "does not work" mean? Keep in mind the fact that all of the "IsValid" functions require a string input, the goal being to see if the string can be successfully converted to the target data type before you actually effect the conversion.
Are you saying that IsValidDecimal("Prasoon") returns TRUE?
-craig
"You can never have too many knives" -- Logan Nine Fingers
I have implemented same scenario in our project to validate whether the input value is character or integer/decimal.
For implementing the same we have use the following function in Transfomer Stage:
Syntax: IF (IsValid("Int32",INPUTCOLUMN") THEN 'Y' ELSE 'N')
When in the input value is integer/decimal it returns 'Y' otherwise it returns 'N'.
You use this logic. I am sure it will work!
Let me know if you need any more details regarding the same.
Hi
Decimal is not a valid integer, then how come you are getting 'Y' for decimals
If you are in 8.x version then it may be due to datastage Behaving differently in 8.1 or 8.5 .
check below link.
SURA's suggestion is valid - what happens if you try the base IsValid() function with the "decimal" option rather than IsValidDecimal(), do you see the same behavior? From what I've read, they are not the same - the latter is not a 'shortcut' to the former.
Last edited by chulett on Mon Sep 02, 2013 7:52 am, edited 1 time in total.
-craig
"You can never have too many knives" -- Logan Nine Fingers