MQSeries.net :: View topic - Broker Namr from ESQL

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Broker Namr from ESQL

Broker Namr from ESQL

« View previous topic :: View next topic »

Author

Message

sarbajit

Posted: Mon Mar 20, 2006 9:46 pm Post subject: Broker Namr from ESQL

Acolyte

Joined: 22 May 2003
Posts: 53

Please let me know how can we get the broker name via ESQL statement. We have multiple brokers installed in same server. It will help me to remove hardcoding in message flows if it is possible to get the broker name in ESQL code. I am using WBIMB 5.0 on AIX.

Thanks in advance

elvis_gn

Posted: Mon Mar 20, 2006 10:27 pm Post subject:

Padawan

Joined: 08 Oct 2004
Posts: 1905
Location: Dubai

Hi sarbajit,

http://www.mqseries.net/phpBB2/viewtopic.php?t=8349&postdays=0&postorder=asc&highlight=broker%20name%20esql&start=0

Regards.

wschutz

Posted: Tue Mar 21, 2006 2:41 am Post subject:

Jedi Knight

Joined: 02 Jun 2005
Posts: 3316
Location: IBM (retired)

I realize that you are using V5, but in V6, it is a lot easier:

Code:

DECLARE mybroker CHARACTER;
SET mybroker = BrokerName;

Plus, you can get other fun stuff, such as:
ExecutionGroupLabel
BrokerDataSourceUserId
QueueManagerName...

The infocenter lists them all.

_________________
-wayne

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Broker Namr from ESQL

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