| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| SUBSTRING with BEFORE/AFTER keyword not supported? |
« View previous topic :: View next topic » |
| Author |
Message
|
| haeberm |
 Posted: Tue Dec 23, 2008 4:55 am Post subject: SUBSTRING with BEFORE/AFTER keyword not supported? |
 |
|
Newbie
Joined: 23 Dec 2008
Posts: 9
|
Hello,
I'm trying to use the SUBSTRING function with BEFORE/AFTER clause. However my toolkit (WMBT6.1.0.3) doesn't like that and reports a syntax error.
Does anybody have an idea what's wrong here? |
|
| Back to top |
|
 |
| mgk |
| Posted: Tue Dec 23, 2008 5:41 am Post subject: |
|
|
Padawan
Joined: 31 Jul 2003
Posts: 1642
|
Hello,
This looks like a defect in the tooling, please raise a PMR for this.
In the meantime to continue your testing, you can use an ESQL "Executable Comment" to bypass the syntax checker in the tooling and deploy the code to the runtime where it will be parsed and executed as if the comment was not there. For example:
| Code: |
| /*!{ SET OutputRoot.XMLNSC.Test = SUBSTRING( 'Fred' AFTER 'e' ) ; }!*/ |
Regards,
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions. |
|
| Back to top |
|
|
| haeberm |
| Posted: Tue Dec 23, 2008 11:50 am Post subject: |
|
|
Newbie
Joined: 23 Dec 2008
Posts: 9
|
Thanks for the quick response.
It does not seem to be a problem of the toolkit alone, though: When I try to deploy the bar file I get:
BIP2401E: (.xxxxxx_xxxxxx.Main, 43.34) : Syntax error : expected 'FROM' but found 'BEFORE'.
Of course I can work around this using the other syntax (it's just not that elegant, you know!)
I'm not sure if I am able to open a PMR since I am an IBM employee, not a customer, I'll try to figure out |
|
| Back to top |
|
|
| mgk |
| Posted: Tue Dec 23, 2008 11:53 am Post subject: |
|
|
Padawan
Joined: 31 Jul 2003
Posts: 1642
|
If the runtime does not accept the syntax either, then it looks like you are not at 6.1.0.3 level...
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions. |
|
| Back to top |
|
|
| haeberm |
| Posted: Tue Dec 23, 2008 12:42 pm Post subject: |
|
|
Newbie
Joined: 23 Dec 2008
Posts: 9
|
| right, runtime-wise I am at 6102 level. Sorry, missed that. |
|
| 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
|
|
|
|
