| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| How to combine WHERE statement in MQSC |
« View previous topic :: View next topic » |
| Author |
Message
|
| aman.kumar |
 Posted: Wed Aug 16, 2017 1:08 pm Post subject: How to combine WHERE statement in MQSC |
 |
|
Newbie
Joined: 16 Aug 2017
Posts: 7
|
Hello Experts,
I am trying to combine the WHERE statement during "DIS QSTATUS" but I am not getting any successful results, anyone here has tried that?
Following commands I tried but each time failed
#1.
echo "dis qs(T1T1) type(handle) all where (PID NE 14759 and TID EQ 1)" | runmqsc QMGR1
got an error as - AMQ8569: Error in filter specification
#2.
echo "dis qs(T1T1) type(handle) all where (PID NE 14759) AND (TID EQ 1)" | runmqsc QMGR1
This one failed too.
If someone knows a way around it, please share. |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Wed Aug 16, 2017 3:11 pm Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
MQSC is not designed to be a monitoring tool.
The WHERE clause is not designed to be a SELECT statement.
Write a PCF program. It's very easy using the java PCF classes.
_________________
chmod -R ugo-wx / |
|
| Back to top |
|
|
| gbaddeley |
| Posted: Wed Aug 16, 2017 5:09 pm Post subject: |
|
|
Jedi Knight
Joined: 25 Mar 2003
Posts: 2538
Location: Melbourne, Australia
|
WHERE can only be specified once in a DISPLAY command, and it only supports one condition, and does not allow filtering on the object name. Its capabilities are therefore quite limited 
_________________
Glenn |
|
| Back to top |
|
|
| hughson |
| Posted: Sat Aug 19, 2017 8:35 pm Post subject: |
|
|
Padawan
Joined: 09 May 2013
Posts: 1964
Location: Bay of Plenty, New Zealand
|
If you want multiple WHERE clauses you could of course look into MQSCX
_________________
Morag Hughson @MoragHughson
IBM MQ Technical Education Specialist
Get your IBM MQ training here!
MQGem Software |
|
| 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
|
|
|
|
