IsValidDecimal issue in IIS8.7

prasson_ibm · Post by **prasson_ibm** » Mon Sep 02, 2013 9:13 am

Hi There,

I have done below tests :-

IsValid("decimal[12,2]","1234567891011.123")=0
IsValid("decimal[12,2]","12345.12")=1
IsValid("decimal[12,2]","ABC01")=0
IsValid("decimal[12,2]","12345,12")=0

It seems to working fine.Thanks a lot for help.

But still we have question on IsValidDecimal() why it is not working as expected.

chulett · Post by **chulett** » Mon Sep 02, 2013 9:25 am

Again, that's a question for your official support provider.

ArndW · Post by **ArndW** » Mon Sep 02, 2013 10:01 am

prasson_ibm wrote:..But still we have question on IsValidDecimal() why it is not working as expected...

IsValidDecimal takes a DECIMAL as the parameter and checks for the other possible errors. Thus using IsValidDecimal("Hello") implictly converst "Hello" to a decimal, resulting in 0, which in turn is a valid decimal.

chulett · Post by **chulett** » Mon Sep 02, 2013 2:39 pm

Interesting... if it's already in a decimal data type, what 'possible errors' are we talking about? Precision and scale?

ray.wurlod · Post by **ray.wurlod** » Mon Sep 02, 2013 11:17 pm

prasson_ibm wrote:...it is not working as expected.

What do you expect, and what do you get when "it is not working as expected"?

What exact version of DataStage (from Help About)?

ArndW · Post by **ArndW** » Tue Sep 03, 2013 2:37 am

chulett wrote:Interesting... if it's already in a decimal data type, what 'possible errors' are we talking about? Precision and scale?

That confused me as well as it doesn't seem to make sense, but as you noted it is the scale and precision as well as the zero-value-flag that is checked for.

ray.wurlod · Post by **ray.wurlod** » Tue Sep 03, 2013 3:55 am

I think you'll find that all the IsValid... functions expect a string as the principal argument. They report whether the string could be validly converted.

SURA · Post by **SURA** » Tue Sep 03, 2013 11:38 pm

I raised a PMR with IBM for the same issue and just now IBM confirmed, it seems bug in the code. They have recommended to use IsValid for now.

prasson_ibm · Post by **prasson_ibm** » Wed Sep 04, 2013 4:49 am

Thanks Sura and everyone.

SURA · Post by **SURA** » Wed Sep 11, 2013 7:41 pm

Today i got the feedback from IBM.

IBM wrote:They said that the parameter of isValidDecimal had to be a decimal value.
They promised to enhance the document to avoid misleading although it would take a while.

That means isValidDecimal needs a proper decimal as an input.

SURA · Post by **SURA** » Wed Sep 11, 2013 10:44 pm

One more point.

IBM wrote:isValidDecimal() is specific for the range lookup of an already existing decimal value.