| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| ESQL 'CONTAINS' Function in Toolkit 6.1.0.3 |
« View previous topic :: View next topic » |
| Author |
Message
|
| Luke |
 Posted: Fri Sep 11, 2009 6:51 am Post subject: ESQL 'CONTAINS' Function in Toolkit 6.1.0.3 |
 |
|
Centurion
Joined: 10 Nov 2008
Posts: 128
Location: UK
|
Hi,
My Toolkit doesn't seem to want to recognise the CONTAINS function. When I code something like:
| Code: |
| IF CONTAINS(refLoad.manifestDescription, refMail.EXT_VALUE) THEN |
I get a red cross saying 'Incorrect function or procedure name "CONTAINS" or argument count.'
Also, get the same for STARTSWITH and ENDSWITH functions. Has anyone else seen this? I've had a look at toolkit fixpack 4 description, but I don't see any mention of a fix relating to this. Would try installing it, but I'll be in the pub by the time it finishes downloading ...
Anyone else seen this? Anyone on 6.1.0.4 know if it's OK in their toolkit?
Or am I doing something stupid (if so, go easy on me, it's Friday afternoon)
Thanks
P.S. I know I can use POSITION and check for 0 return instead ... but it's in the infocenter and I wanted to use it! |
|
| Back to top |
|
 |
| Vitor |
| Posted: Fri Sep 11, 2009 8:05 am Post subject: Re: ESQL 'CONTAINS' Function in Toolkit 6.1.0.3 |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| Luke wrote: |
Or am I doing something stupid (if so, go easy on me, it's Friday afternoon)
|
Well you didn't use the search function, which is a little stupid! 
If you had, you'd have found this which describes this problem exactly, and the resolutions to it.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| Luke |
| Posted: Fri Sep 11, 2009 8:42 am Post subject: |
|
|
Centurion
Joined: 10 Nov 2008
Posts: 128
Location: UK
|
No, that's a lot stupid. Thanks for saying "a little". I did search, but Google, which obviously threw up huge numbers of irrelevant results for contains and esql ...
Must use the search button here in future, sorry ... |
|
| Back to top |
|
|
| WMBDEV1 |
| Posted: Fri Sep 11, 2009 4:44 pm Post subject: |
|
|
Sentinel
Joined: 05 Mar 2009
Posts: 888
Location: UK
|
| Luke wrote: |
No, that's a lot stupid. Thanks for saying "a little". I did search, but Google, which obviously threw up huge numbers of irrelevant results for contains and esql ...
Must use the search button here in future, sorry ... |
Never mind, i've found you're other comments to be pretty much spot on, just make sure you bite your tongue before saying "search the forum" to some lazy poster until we've all forgot this day  |
|
| 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
|
|
|
|
