Hello,

At my organization we have a naming convention for qmgrs like XXXX_T2, where T2 is the test environment identifier.

I'd like set up an automatic set in MQExplorer for all the T2 queue managers, but the % character is not working like in SQL (LIKE %T2).

I found no reference in the documentation, how to use the LIKE operation, specifically in this case.

Does anybody know the answer?

Greetings,

Robert

------------------------------
Grebenár Róbert
------------------------------

Hi @Grebenár Róbert 

the IBM MQ API only supports wildcards at the end of a queue manager name so something like T2_* would work correctly. There are additional tools like for example https://www.mqgem.com/mo71.html who support wildcards even within the queue name or as a prefix of the name.

In addition you could for example at Linux make use of the runmqsc command line and use the display-command and its output and pipe that through a grep in order to filter the output using even regular expressions.

Kind regards
Jan

------------------------------
Jan Frederik Sorge
------------------------------

Infrared360 from Avada Software has always had this functionality since the very first version in 2006.  You can also save these queries as bookmarks for you or your users to use.  It also works for monitoring.

------------------------------
Peter D'Agosta
Product Manager
Avada Software
Rockaway NJ
19737273847
------------------------------

Original Message:
Sent: Mon April 03, 2023 06:53 AM
From: Jan Frederik Sorge
Subject: MQExplorer automatic set: LIKE operation wirldcards

Hi @Grebenár Róbert 

the IBM MQ API only supports wildcards at the end of a queue manager name so something like T2_* would work correctly. There are additional tools like for example https://www.mqgem.com/mo71.html who support wildcards even within the queue name or as a prefix of the name.

In addition you could for example at Linux make use of the runmqsc command line and use the display-command and its output and pipe that through a grep in order to filter the output using even regular expressions.

Kind regards
Jan

------------------------------
Jan Frederik Sorge
------------------------------

Hello Jan,
thanks for the information and suggestions. I know 3rd party possibilities, just wanted to solve it from MQExplorer. It was hard to believe that * is supported only at the end, when the keyword is LIKE.
Greetings,
Robert

------------------------------
Grebenár Róbert
------------------------------

Original Message:
Sent: Mon April 03, 2023 06:53 AM
From: Jan Frederik Sorge
Subject: MQExplorer automatic set: LIKE operation wirldcards

Hi @Grebenár Róbert 

the IBM MQ API only supports wildcards at the end of a queue manager name so something like T2_* would work correctly. There are additional tools like for example https://www.mqgem.com/mo71.html who support wildcards even within the queue name or as a prefix of the name.

In addition you could for example at Linux make use of the runmqsc command line and use the display-command and its output and pipe that through a grep in order to filter the output using even regular expressions.

Kind regards
Jan

------------------------------
Jan Frederik Sorge
------------------------------

Unfortunately "if the wildcard character * is used, it must be the final character".
Thanks anyway!

------------------------------
Grebenár Róbert
------------------------------

Original Message:
Sent: Tue April 04, 2023 06:30 PM
From: vinay kumar
Subject: MQExplorer automatic set: LIKE operation wirldcards

I think you can use  .*_T2$ .

Regards

Vinay Kumar