| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Using Select with <> operator in WMQI - I can't use it |
« View previous topic :: View next topic » |
| Author |
Message
|
| marcioalcantara |
 Posted: Wed May 22, 2002 8:55 am Post subject: Using Select with <> operator in WMQI - I can't use it |
 |
|
Novice
Joined: 25 Jun 2001
Posts: 23
|
Hi, All.
I'm trying to use the <> operator in a Compute node. But I'm unable to put a double quote (") in the start and end of the SQL clause in a Compute or Database nodes...
SET COUNT_LITM =
(SELECT COUNT(T.LITM)
FROM Database.MQADM.F4101 AS T
WHERE T.LITM = "InputBody"."CODE_PRODUCT_VEN" AND T.SRP9 <> '0');
And this clause only works with double quote...
Does anyone have any idea how I can do it?
Thanks a lot
Last edited by marcioalcantara on Wed May 22, 2002 9:06 am; edited 1 time in total |
|
| Back to top |
|
 |
| kirani |
| Posted: Wed May 22, 2002 9:03 am Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Can you post your ESQL here?
_________________
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 |
|
|
| kirani |
| Posted: Wed May 22, 2002 9:35 am Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Your ESQL is correct and I don't see any reason why it should fail. You can use corelation/element names within double quotes ("") in Compute or Database nodes.
Did you get any error while deploy this message flow or is it showing up as syntax error in Compute node (in control center)? What version of WMQI are you using?
_________________
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 |
|
|
| marcioalcantara |
| Posted: Wed May 29, 2002 11:23 am Post subject: |
|
|
Novice
Joined: 25 Jun 2001
Posts: 23
|
|
| 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
|
|
|
|
