| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Alternative for LASTMOVE |
« View previous topic :: View next topic » |
| Author |
Message
|
| Sridar |
 Posted: Wed Jun 21, 2006 8:58 pm Post subject: Alternative for LASTMOVE |
 |
|
Acolyte
Joined: 14 May 2006
Posts: 72
Location: Chennai, India
|
Hi
I want to check whether this field exists or not(not the value)
" InputRoot.MRM.EventInfo.ProductEvent. "
I created a reference and used LASTMOVE but i got a comment that LASTMOVE will affect Performance.
Is it so and If so is there an alternative
_________________
Thanks and Regards
Sridar |
|
| Back to top |
|
 |
| elvis_gn |
| Posted: Wed Jun 21, 2006 9:11 pm Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi Sridar,
U can use EXISTS.
Regards. |
|
| Back to top |
|
|
| Sridar |
| Posted: Wed Jun 21, 2006 9:54 pm Post subject: |
|
|
Acolyte
Joined: 14 May 2006
Posts: 72
Location: Chennai, India
|
Hi
Isn't EXISTS used for a Database SELECT statement generally?
Correct me if i am wrong.
I could find only Examples for this.
If not can you tell me how to use it for my requirement.
It tried using the below code but i am getting error that " Valid Options include SELECT"
IF EXISTS(InputRoot.MRM.EventInfo.ProductEvent) THEN
Statements
ELSE
Statements
END IF;
_________________
Thanks and Regards
Sridar |
|
| Back to top |
|
|
| elvis_gn |
| Posted: Wed Jun 21, 2006 10:56 pm Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi Sridar,
Its not that it can be used only with SELECT, the problem is that the field should be a list...i.e
| Code: |
| IF EXISTS(InputRoot.MRM.EventInfo.ProductEvent[]) THEN |
will work...
Else, what u could do is use the COALESCE and then check the value with an IF condition...
Regards. |
|
| 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
|
|
|
|
