| Author |
Message
|
| mchillin |
 Posted: Thu Mar 01, 2007 3:22 am Post subject: modify message flow properties from a compute node |
 |
|
Novice
Joined: 27 Sep 2006
Posts: 16
|
Is it possible to modify the message flow properties using ESQL code or Java (Java Compute)?
For Example: Modify the database origin.
Thanks in advance for any advise. |
|
| Back to top |
|
 |
| au@kosa |
| Posted: Thu Mar 01, 2007 3:28 am Post subject: |
|
|
Centurion
Joined: 04 Jan 2007
Posts: 103
Location: pune
|
Do you want to change the value of the parameter, once set in the property window of the built in node?
_________________
Regards,
au@kosa
IBM Certified SOA Solution Designer/Associate |
|
| Back to top |
|
|
| mchillin |
| Posted: Thu Mar 01, 2007 3:41 am Post subject: |
|
|
Novice
Joined: 27 Sep 2006
Posts: 16
|
|
| Back to top |
|
|
| elvis_gn |
| Posted: Thu Mar 01, 2007 3:51 am Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi mchillin,
You can't change the value in the node, but you definitely can access some other datasource in the compute....
Actually you can access other datasources of the same type(by type I mean DB2, Oracle etc) you cannot mix them though in a compute.
Regards. |
|
| Back to top |
|
|
| au@kosa |
| Posted: Thu Mar 01, 2007 3:53 am Post subject: |
|
|
Centurion
Joined: 04 Jan 2007
Posts: 103
Location: pune
|
Could you please elaborate what exactly you want to do by changing the value through C.N or J.C.N.
_________________
Regards,
au@kosa
IBM Certified SOA Solution Designer/Associate |
|
| Back to top |
|
|
| au@kosa |
| Posted: Thu Mar 01, 2007 3:58 am Post subject: |
|
|
Centurion
Joined: 04 Jan 2007
Posts: 103
Location: pune
|
|
| Back to top |
|
|
| mchillin |
| Posted: Thu Mar 01, 2007 4:30 am Post subject: |
|
|
Novice
Joined: 27 Sep 2006
Posts: 16
|
To explain a little futher. The intention is to be able to change the name of the Database used in the message flow when changing between different environments.
For example: By checking mybrokername we can see in which environment we are in and from that we wanted to change the Database used in the message flow to coinside with that environment.
Is this possible? |
|
| Back to top |
|
|
| elvis_gn |
| Posted: Thu Mar 01, 2007 4:40 am Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi mchillin,
Why should your broker name decide the database to connect to...
What you should do is make a general DSN name as say "APPDB", put that in your compute node, and then in every environment have that environment's database linked to that DSN name....
Thus automatically you would be connecting to the correct Db, without having to touch your flow....this will help especially when ur fixing defects and moving flows across environments...and make ur flow performance better...
Regards. |
|
| Back to top |
|
|
| au@kosa |
| Posted: Thu Mar 01, 2007 5:10 am Post subject: |
|
|
Centurion
Joined: 04 Jan 2007
Posts: 103
Location: pune
|
| Quote: |
| The intention is to be able to change the name of the Database used in the message flow when changing between different environments |
Then one of the option is to promote the DSN name property of the compute node and change the value of this property while deploying the bar file into the broker.
_________________
Regards,
au@kosa
IBM Certified SOA Solution Designer/Associate |
|
| Back to top |
|
|
| mchillin |
| Posted: Thu Mar 01, 2007 5:33 am Post subject: |
|
|
Novice
Joined: 27 Sep 2006
Posts: 16
|
| Quote: |
| promote the DSN name property of the compute node and change the value of this property while deploying the bar file into the broker |
This is what we are currently doing but we want these properties to be dynamic according to the environment that the are used.
We also have other properties to bear in mind as we are using the z/OS CICS node, which has properties that change between the development and production environment. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu Mar 01, 2007 5:46 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
You can look at User Defined Properties in v6, for some of this. But you can't change node properties except at deploytime.
For things like queue names for output, you can use DestinationLists built from a database or UDPs or etc. For things like DSN names, you can code dynamic DSNs in v6.
For things like queues being read by MQInput nodes or HTTPInput URLs, you can't change them except at deploytime.
Well, you could run the risk of destroying your entire environment and being unsupported, and consider dynamically updating the broker database from within broker.
But that's an idea that is epic in horribleness.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| mchillin |
| Posted: Thu Mar 01, 2007 5:53 am Post subject: |
|
|
Novice
Joined: 27 Sep 2006
Posts: 16
|
OK, that has cleared up a few doubts.
Thanks for the help. |
|
| Back to top |
|
|
|
|
