| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| The problem of using CREATE FUNCTION in ESQL |
« View previous topic :: View next topic » |
| Author |
Message
|
| Yanghui |
 Posted: Mon May 27, 2002 2:20 am Post subject: The problem of using CREATE FUNCTION in ESQL |
 |
|
Disciple
Joined: 08 May 2002
Posts: 151
Location: Dublin, Ireland
|
Hi,
 No matter how I tried, I just couldn't make CREATE FUNCTION work in Compute node in WMQI2.1 even the sample in manual. The sample is:
DECLARE X INTEGER;
SET X =2;
DECLARE Y INTEGER;
SET Y =MultiplyByTwo(X);
CREATE FUNCTION MultiplyByTwo(Value INTEGER)RETURNS INTEGER
RETURN Value *2;
I always got a syntax error right after MultiplyByTwo in Compute Note. I have no clue what mistake I made. Does anyone know how to use CREATE FUNCTION? Any trick?
Thanks a lot in advance.
Regards
-Yanghui |
|
| Back to top |
|
 |
| kirani |
| Posted: Mon May 27, 2002 9:23 am Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Yanghui,
Are you getting syntax error in your control center or are you getting an error while doing a deploy? CREATE FUNCTION is available in CSD2 so make sure you have that installed on your 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 |
|
|
| Yanghui |
| Posted: Tue May 28, 2002 12:05 am Post subject: |
|
|
Disciple
Joined: 08 May 2002
Posts: 151
Location: Dublin, Ireland
|
Hi, Kiran,
Thanks a lot for your reply.
The syntax error I got is in the Control Center.
I haven't had CSD2 for my WMQI2.1 but I will. I didn't realize that CREATE FUNCTION is only available in the CSD2. Interesting. Hope CSD2 will solve my problem.
It's not convenient without subroutine in ESQL. Hope CREATE FUNCTION will make my ESQL more efficient. Subflow can be useful sometimes but it's not flexible enough.
Thanks again & Regards
-Yanghui |
|
| 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
|
|
|
|
