| 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. |
|
| Back to top |
|
 |
| 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. |
|
| Back to top |
|
|
| 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. |
|
| Back to top |
|
|
| 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. |
|
| Back to top |
|
|
|
|
