| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Combining multiple where statements in MQSC script |
« View previous topic :: View next topic » |
| Author |
Message
|
| vicks_mq |
 Posted: Sun May 20, 2018 11:36 am Post subject: Combining multiple where statements in MQSC script |
 |
|
Disciple
Joined: 03 Oct 2017
Posts: 162
|
Hi, I am trying unsuccessfully to combine multiple "Where" clause in the MQSC script.
We just did a minor upgrade on our MQ system and I want to ensure that after the upgrade all the client applications are processing (putting/getting) messages from queue sucessfully.
So I tried to combine the where clause where the Queue last Get time is null and current depth is greater than 0. it will tell me whether the request/response is working or the queue is just piling up the request messages.
the command I tried is
dis qs(PRODQM1.*) where(LGETTIME EQ '' and curdepth GT 0)
But I got an error saying it is not valid syntax,
I am wondering how can I combine multiple "WHERE" statements? |
|
| Back to top |
|
 |
| fjb_saper |
| Posted: Sun May 20, 2018 11:44 am Post subject: Re: Combining multiple where statements in MQSC script |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| vicks_mq wrote: |
Hi, I am trying unsuccessfully to combine multiple "Where" clause in the MQSC script.
We just did a minor upgrade on our MQ system and I want to ensure that after the upgrade all the client applications are processing (putting/getting) messages from queue sucessfully.
So I tried to combine the where clause where the Queue last Get time is null and current depth is greater than 0. it will tell me whether the request/response is working or the queue is just piling up the request messages.
the command I tried is
dis qs(PRODQM1.*) where(LGETTIME EQ '' and curdepth GT 0)
But I got an error saying it is not valid syntax,
I am wondering how can I combine multiple "WHERE" statements? |
AFAIK MQSCAUX tool from Paul can do that but not standard runmqsc... (and I have no interest in Paul's company...)
You could also try and create a PCF message to see if you get the desired result... 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| PeterPotkay |
| Posted: Mon May 21, 2018 4:30 pm Post subject: Re: Combining multiple where statements in MQSC script |
|
|
Poobah
Joined: 15 May 2001
Posts: 7722
|
| fjb_saper wrote: |
AFAIK MQSCAUX tool from Paul can do that but not standard runmqsc... (and I have no interest in Paul's company...) |
That tool by MQGem is called MQSCX.
Capitalware's Exit (one of) is MQAUSX.
_________________
Peter Potkay
Keep Calm and MQ On |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Tue May 22, 2018 7:05 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Thanks for setting me straight Peter.
_________________
MQ & Broker admin |
|
| 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
|
|
|
|
