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 IndexGeneral IBM MQ SupportCombining multiple where statements in MQSC script

Post new topicReply to topic
Combining multiple where statements in MQSC script View previous topic :: View next topic
Author Message
vicks_mq
PostPosted: Sun May 20, 2018 11:36 am Post subject: Combining multiple where statements in MQSC script Reply with quote

Novice

Joined: 03 Oct 2017
Posts: 18

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
View user's profile Send private message
fjb_saper
PostPosted: Sun May 20, 2018 11:44 am Post subject: Re: Combining multiple where statements in MQSC script Reply with quote

Grand Poobah

Joined: 18 Nov 2003
Posts: 19701
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
View user's profile Send private message Send e-mail
PeterPotkay
PostPosted: Mon May 21, 2018 4:30 pm Post subject: Re: Combining multiple where statements in MQSC script Reply with quote

Jedi Council

Joined: 15 May 2001
Posts: 7431

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
View user's profile Send private message
fjb_saper
PostPosted: Tue May 22, 2018 7:05 pm Post subject: Reply with quote

Grand Poobah

Joined: 18 Nov 2003
Posts: 19701
Location: LI,NY

Thanks for setting me straight Peter.
_________________
MQ & Broker admin
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:
Post new topicReply to topic Page 1 of 1

MQSeries.net Forum IndexGeneral IBM MQ SupportCombining multiple where statements in MQSC script
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.