| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Message not failing.. help!!! |
« View previous topic :: View next topic » |
| Author |
Message
|
| aaron_blade |
 Posted: Sun Feb 14, 2010 3:15 pm Post subject: Message not failing.. help!!! |
 |
|
Apprentice
Joined: 21 Dec 2009
Posts: 29
|
Hi,
I have a map where i am typecasting a string to an integer for an attribute.
I used TEXTTOINTEGER function to do the same.
I have a question here, when I give some numeric value say 123 as input value it is getting properly converted to number as i am using the function as mentioned above. When I give abc as value in input, the value dosnt showup in my out file.
what I expected here is it should fail but type tree is passing it ahead.
Can any one explain me whats happeing here..
Thanking you in advance!!
AAron... |
|
| Back to top |
|
 |
| Vitor |
| Posted: Sun Feb 14, 2010 3:59 pm Post subject: Re: Message not failing.. help!!! |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| aaron_blade wrote: |
I used TEXTTOINTEGER function to do the same.
|
Ok, not familiar with the mapping node but I've never heard of that function or an ESQL equivalent. 
Moving on, it sounds a lot like whatever the function is doesn't fail if there's invalid input, it simply returns NULL. Try that.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| aaron_blade |
| Posted: Sun Feb 14, 2010 5:40 pm Post subject: |
|
|
Apprentice
Joined: 21 Dec 2009
Posts: 29
|
My Apologies...
I am using WTX for map development.
IT is returning NULL...
but my question is why is it not failing? |
|
| Back to top |
|
|
| Vitor |
| Posted: Sun Feb 14, 2010 5:49 pm Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| aaron_blade wrote: |
| I am using WTX for map development. |
Ok, so I'm well outside my area of expertise.
| aaron_blade wrote: |
IT is returning NULL...
but my question is why is it not failing? |
Guessing (as indicated above) but from the available evidence I'd say this function returns NULL if it can't do the conversion. It almost certainly does this because whoever wrote the function decided it should return NULL under these circumstances rather than throw an error. The product documentation will have more information.
FWIW I've seen a number of functions over the years in various languages that do this sort of thing for good & sufficient reason (an example would be substituting a default value where invalid data's been provided). As I've said, I'm only theorising as I don't know in this case or this product.
Again going on theory it doesn't sound too tricky to get an error out if you wanted one.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
