MQSeries.net :: View topic - SUBSTRING Raising Error

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » SUBSTRING Raising Error

SUBSTRING Raising Error

« View previous topic :: View next topic »

Author

Message

arunkumar1989

Posted: Tue Dec 11, 2012 11:18 pm Post subject: SUBSTRING Raising Error

Voyager

Joined: 21 Nov 2012
Posts: 98
Location: Chennai

SET lable='MyFlow.HTTPInput';

SET flowName = SUBSTRING(label BEFORE '.');
SET nodeName = SUBSTRING(label AFTER '.');

Error :

Syntax error. Valid options include: || / = >= > <= < - <> + *
AND BETWEEN DAY FROM HOUR IN IS LIKE MINUTE MONTH
NOT OR SECOND YEAR ErrorSubFlow ErrorSubFlowFlow.esql line 25 1356333758843 12758
_________________
Being in a crowd when you are alone is ignorance. Enlightenment is being alone in a crowd; a feeling of oneness in a crowd.

Esa

Posted: Wed Dec 12, 2012 12:39 am Post subject: Re: SUBSTRING Raising Error

Grand Master

Joined: 22 May 2008
Posts: 1387
Location: Finland

arunkumar1989 wrote:

Code:

SET lable='MyFlow.HTTPInput';

SET flowName = SUBSTRING(label BEFORE '.');
SET nodeName = SUBSTRING(label AFTER '.');

lable, label ? Maybe you get the syntax error because you are accessing a variable that has not been declared?

Hint: the little yellow warning signs in the left side of the editor window point to places where you may have made typos. The best practice is to make sure that you have none of those.

arunkumar1989

Posted: Wed Dec 12, 2012 10:53 pm Post subject:

Voyager

Joined: 21 Nov 2012
Posts: 98
Location: Chennai

I have resolved this error using following code :

SET FLOWNAME = SUBSTRING(LBL FROM 1 FOR POSITION('.' IN label)-1);
SET NODENAME = SUBSTRING(LBL FROM POSITION('.' IN label)+1);

If i wants to use this mean

SET flowName = SUBSTRING(label BEFORE '.');
SET nodeName = SUBSTRING(label AFTER '.');

we need to do fix pack.

we can get fix pack from following url

http://www-01.ibm.com/support/docview.wss?uid=swg27006041#61
_________________
Being in a crowd when you are alone is ignorance. Enlightenment is being alone in a crowd; a feeling of oneness in a crowd.

Vitor

Posted: Thu Dec 13, 2012 4:06 am Post subject:

Grand High Poobah

Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA

arunkumar1989 wrote:

we need to do fix pack.

How do you expect us to know when you've not mentioned what level you're using?

Typically you'd always do fix pack.
_________________
Honesty is the best policy.
Insanity is the best defence.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » SUBSTRING Raising Error

Jump to:

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

Protected by Anti-Spam ACP