ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » General IBM MQ Support » Combining WHERE clause in MQSC command

Post new topic  Reply to topic Goto page Previous  1, 2
 Combining WHERE clause in MQSC command « View previous topic :: View next topic » 
Author Message
hughson
PostPosted: Mon Nov 05, 2018 8:42 pm    Post subject: Reply with quote

Padawan

Joined: 09 May 2013
Posts: 1914
Location: Bay of Plenty, New Zealand

bruce2359 wrote:
The equivalent of MQSC WHERE is filters in the MQExplorer and MQCONSOLE.

I don't have access to an image right now, so I can't valudate that filters work with QSTATUS, but they certainly works with Queues, queue managers, and other objects.

MQExplorer filters are discussed in IBM official curriculum.

Yes indeed, "Filters" is indeed the MQ Explorer name for "the WHERE clause".

I can confirm that MQ Explorer filters work with QSTATUS just as the MQSC WHERE clause does (they are the same thing after all, one in PCF and one in MQSC spelling). I just brought up an MQ Explorer to double check.

You said that MQ Explorer filters could do ANDs and ORs though (like the OP wanted) - that's what I was asking you to clarify. I don't believe that is true. Maybe that wasn't what you were trying to say?

Cheers,
Morag
_________________
Morag Hughson @MoragHughson
IBM MQ Technical Education Specialist
Get your IBM MQ training here!
MQGem Software
Back to top
View user's profile Send private message Visit poster's website
krypton
PostPosted: Tue Nov 06, 2018 8:05 am    Post subject: Reply with quote

Disciple

Joined: 14 Mar 2010
Posts: 186

Hi Morgan,

I just checked MQ Explorer again (V and I can confirm that the FILTERS doesn't work with QSTATUS parameters( like IPPROCS, OPPROCS, APPTAG, LEGTTIME and so on..)
it only works with Queue attributes like (BOThreshold, Usage , get /put enabled etc etc).

If you have find that it works with Qstatus, let me know where I can look for it.

hughson wrote:
bruce2359 wrote:
The equivalent of MQSC WHERE is filters in the MQExplorer and MQCONSOLE.

I don't have access to an image right now, so I can't valudate that filters work with QSTATUS, but they certainly works with Queues, queue managers, and other objects.

MQExplorer filters are discussed in IBM official curriculum.

Yes indeed, "Filters" is indeed the MQ Explorer name for "the WHERE clause".

I can confirm that MQ Explorer filters work with QSTATUS just as the MQSC WHERE clause does (they are the same thing after all, one in PCF and one in MQSC spelling). I just brought up an MQ Explorer to double check.

You said that MQ Explorer filters could do ANDs and ORs though (like the OP wanted) - that's what I was asking you to clarify. I don't believe that is true. Maybe that wasn't what you were trying to say?

Cheers,
Morag

_________________
Dreams are not something which you watch when you are asleep,it is something which doesn't let you sleep.
Back to top
View user's profile Send private message
hughson
PostPosted: Tue Nov 06, 2018 1:01 pm    Post subject: Reply with quote

Padawan

Joined: 09 May 2013
Posts: 1914
Location: Bay of Plenty, New Zealand

krypton wrote:
If you have find that it works with Qstatus, let me know where I can look for it.
  1. Open up a Queue Status list
    Right click on the Queues folder in the Navigator pane and choose Status... from the context menu
  2. Open up the filter to edit
    Just above the list of queues shown in the Queue Status list, you should see "Filter: Standard for Queue Status". At the far right of that text is a down arrow. Click on that down arrow and select, "Edit Current Filter..."
  3. Add the attribute you wish to filter on
    Click the check box next to "-AND", press the "Select..." button and choose the attribute you wish, e.g. "Open input count", and set the rest of the expression. Click on OK when done.
If this isn't clear, please let me know which part doesn't work.

P.S. Please note that not all the attributes appear to be available as a filter in this way - i.e. the Put/Get Date/Time attributes don't appear in the list which was where this thread began, and please also note that you cannot add more than one filter with an AND or OR between it, regardless of what @bruce2359 says. Also, it would appear you cannot filter on the handles, only on the queue status. MQSC can give you more than MQ Explorer in this case.

Cheers,
Morag
_________________
Morag Hughson @MoragHughson
IBM MQ Technical Education Specialist
Get your IBM MQ training here!
MQGem Software
Back to top
View user's profile Send private message Visit poster's website
krypton
PostPosted: Tue Nov 06, 2018 1:19 pm    Post subject: Reply with quote

Disciple

Joined: 14 Mar 2010
Posts: 186

Found it, thank you. earlier I was not looking at the navigator pane..

hughson wrote:
krypton wrote:
If you have find that it works with Qstatus, let me know where I can look for it.
  1. Open up a Queue Status list
    Right click on the Queues folder in the Navigator pane and choose Status... from the context menu
  2. Open up the filter to edit
    Just above the list of queues shown in the Queue Status list, you should see "Filter: Standard for Queue Status". At the far right of that text is a down arrow. Click on that down arrow and select, "Edit Current Filter..."
  3. Add the attribute you wish to filter on
    Click the check box next to "-AND", press the "Select..." button and choose the attribute you wish, e.g. "Open input count", and set the rest of the expression. Click on OK when done.
If this isn't clear, please let me know which part doesn't work.

P.S. Please note that not all the attributes appear to be available as a filter in this way - i.e. the Put/Get Date/Time attributes don't appear in the list which was where this thread began, and please also note that you cannot add more than one filter with an AND or OR between it, regardless of what @bruce2359 says. Also, it would appear you cannot filter on the handles, only on the queue status. MQSC can give you more than MQ Explorer in this case.

Cheers,
Morag

_________________
Dreams are not something which you watch when you are asleep,it is something which doesn't let you sleep.
Back to top
View user's profile Send private message
bruce2359
PostPosted: Tue Nov 13, 2018 7:09 am    Post subject: Reply with quote

Poobah

Joined: 05 Jan 2008
Posts: 9394
Location: US: west coast, almost. Otherwise, enroute.

I stand corrected. I finally have a v9 image, and no filter support in the explorer for qstatus. must have been optimism or meds.
_________________
I like deadlines. I like to wave as they pass by.
ב''ה
Lex Orandi, Lex Credendi, Lex Vivendi. As we Worship, So we Believe, So we Live.
Back to top
View user's profile Send private message
hughson
PostPosted: Tue Nov 13, 2018 2:08 pm    Post subject: Reply with quote

Padawan

Joined: 09 May 2013
Posts: 1914
Location: Bay of Plenty, New Zealand

bruce2359 wrote:
I stand corrected. I finally have a v9 image, and no filter support in the explorer for qstatus. must have been optimism or meds.

Please see my previous post in this thread. There IS filtering for QSTATUS in MQ Explorer, but there is no AND/OR which was the original question.

Cheers,
Morag
_________________
Morag Hughson @MoragHughson
IBM MQ Technical Education Specialist
Get your IBM MQ training here!
MQGem Software
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic  Reply to topic Goto page Previous  1, 2 Page 2 of 2

MQSeries.net Forum Index » General IBM MQ Support » Combining WHERE clause in MQSC command
Jump to:  



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
Protected by Anti-Spam ACP
 
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.