| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| How to set dataSource property using ESQL in a Compute Node |
« View previous topic :: View next topic » |
| Author |
Message
|
| ponshy |
 Posted: Mon Jul 08, 2002 11:17 am Post subject: How to set dataSource property using ESQL in a Compute Node |
 |
|
Newbie
Joined: 23 Jun 2002
Posts: 5
|
Hi,
I am trying to set dataSource property in a COMPUTE node using ESQL instead of Property window.
I tried unsuccessfully with
SET OutputRoot.Properties.dataSource = '<database name>' and
SET OutputRoot.Properties.dataSourceName = '<database name>'
I would appreciate if anyone advise me the right syntax or any other way of getting this working. ESQL manual says all IBM supplied nodes will have Property tree (folder) as a first child but I couldn't see them. I am trying to find a way to access this Property tree. I am using WMQI2.1 with CSD03.
Any help appreciated.
Thanks. |
|
| Back to top |
|
 |
| kirani |
| Posted: Mon Jul 08, 2002 4:18 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
There is no such property called dataSource or dataSourceName in Properties folder. However, dataSource is a property of Compute node.
Mostly people get confused between Properties tree folder and Node property. These are two different things.
Valid members of Properties folders (in WMQI 2.1) are:
MessageSet
MessageType
MessageFormat
Encoding
CodedCharSetId
Transactional
Persistence
CreationTime
ExpirationTime
Priority
ReplyIdentifier
ReplyProtocol
Topic
To set values for any member in Properties folder/tree, you can use esql
SET OutputRoot.Properties.MessageSet = '....';
You can promote a propery for a Node by right clicking on it and selecting Promote Property. Once you promote the property for a node, you can set value for it by selecting properties for that sub-flow/main-flow.
I don't think You can use ESQL to set value for promoted property.
Hope this helps.
One more thing ...
| ponshy wrote: |
I am using WMQI2.1 with CSD03.
|
I don't think WMQI 2.1 CSD3 is out yet. Are you sure about the CSD level?
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| mpuetz |
| Posted: Tue Jul 09, 2002 9:02 am Post subject: |
|
|
Centurion
Joined: 05 Jul 2001
Posts: 149
Location: IBM/Central WebSphere Services
|
Hi,
sadly there is no way to set datasources dynamically with
the standard node set, even though MQSI plugin interface
functions would support this.
However it is actually fairly straightforward to create your own plugin
to execute a peace of eSQL dynamically and also setting the
datasource dynamically.
You could write interface to such a plugin using e.g.
the LocalEnvironment
SET LocalEnvironment.MyPlugin.dataSource = 'mysource';
SET LocalEnvironment.MyPlugin.transcational = 'auto';
Such a plugin would then read the dataSource and transaction
properties from the LocalEnvironment and then use the
cniSqlCreateStatement and cniSqlExecute calls to execute
your eSQL with a dynamic datasource.
_________________
Mathias Puetz
IBM/Central WebSphere Services
WebSphere Business Integration Specialist |
|
| Back to top |
|
|
| kirani |
| Posted: Tue Jul 09, 2002 7:03 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Mathis,
Is IBM planning to provide this feature in future releases of WMQI? Providing such simple and small feature will help all of us a lot. Many people end up writing a plug-in node to do such simple processing, which should have been a part of standard WMQI feature. There are so many such features missing in WMQI.
I hope this product will get better with feature releases. 
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| 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
|
|
|
|
