| Author |
Message
|
| cute_pav |
 Posted: Fri Aug 23, 2002 3:15 pm Post subject: ESQL FUNCTIONS |
 |
|
Acolyte
Joined: 04 Jan 2002
Posts: 65
Location: usa
|
I am trying to write function using ESQL.I tried with the same syntax from the document as follows:
CREATE FUNCTION MultiplyByTwo(Value INTEGER) RETURNS INTEGER
RETURN Value * 2;
I don't have any error in editor of the computenode but i am getting the following error while deployment with the broker.
Syntax error : expected 'FIELD, PARENT, PREVIOUSSIBLING, NEXTSIBLING, FIRSTCHILD, LASTCHILD' but found 'integer FUNCTION'
Anyone can shed some views on what is went wrong? |
|
| Back to top |
|
 |
| kirani |
| Posted: Fri Aug 23, 2002 3:25 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Do you have any ESQL code after this function? Try moving function definition towards the end of your ESQL code.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| cute_pav |
| Posted: Fri Aug 23, 2002 3:51 pm Post subject: ESQL FUNCTION |
|
|
Acolyte
Joined: 04 Jan 2002
Posts: 65
Location: usa
|
Kirani,
thankz for prompt reply and suggestion.
I tried the same code all places in editor and also only using the code in compute node.The error remains the same.
Syntax error : expected 'FIELD, PARENT, PREVIOUSSIBLING, NEXTSIBLING, FIRSTCHILD, LASTCHILD' but found 'integer FUNCTION'.
The expected token was not found.
Correct the syntax of your expression and redeploy the message flow.
Any corrections needs to be done on code syntax? |
|
| Back to top |
|
|
| kirani |
| Posted: Fri Aug 23, 2002 4:18 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
I copy/pasted the same code in my MessageFlow and it deployed without any problem.
This feature is available in WMQI 2.1 CSD2 only. Do you have CSD2 installed on your WMQI server?
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| sgopal |
| Posted: Fri Aug 23, 2002 4:23 pm Post subject: |
|
|
Acolyte
Joined: 30 Jul 2002
Posts: 63
|
I think you have not installed CSD2 on your WMQI Server.
Because broker see the CREATE word and it fails when FUNCTION IS USED, it expects 'FIELD, PARENT, PREVIOUSSIBLING, NEXTSIBLING, FIRSTCHILD, LASTCHILD' |
|
| Back to top |
|
|
| cute_pav |
| Posted: Sat Aug 24, 2002 11:59 am Post subject: ESQL FUNCTIONS |
|
|
Acolyte
Joined: 04 Jan 2002
Posts: 65
Location: usa
|
hi,
I am using wmqi2.1 broker in solaris. where can I find(dir) the CSD2 memo.ptf file in this box to confirm whether this serviecelevel applied earlier or not?.Any clues are appreciated.
pavan |
|
| Back to top |
|
|
| kirani |
| Posted: Sat Aug 24, 2002 12:40 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Pavan,
mqmo.ptf file is created only after installing CSD. This file is located in WMQI home directory.
Have a look at,
http://www.mqseries.net/phpBB2/viewtopic.php?t=3508&highlight=memo+ptf
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
|
|
