| Author |
Message
|
| mahesh2069 |
 Posted: Fri Nov 08, 2013 3:30 am Post subject: How to set DSN In compute node ,with out ESQL |
 |
|
Centurion
Joined: 26 Jun 2013
Posts: 103
|
Hai All,
I have one compute node , that is having one of the properties like Data source , I want to change give wrong DSN in compute node , So On compute node , error will rised. So I need to set that DSN Dynamic .
| Quote: |
1 . Is there any ESQL coding to change value of Promote to property ?
2. Is there any chance to change DSN name Dynamically , with out ESQL coding. Like setting DSN value in local environment .
|
Here I Need to run Code in the compute node where we getting error due to give Unregistered DSN name in compute node .
Help Me To Solve this issue.
Than
_________________
Thanks & Regards
Mahesh Mediboyina
WMB Developer |
|
| Back to top |
|
 |
| mahesh2069 |
| Posted: Fri Nov 08, 2013 3:34 am Post subject: |
|
|
Centurion
Joined: 26 Jun 2013
Posts: 103
|
How to change DSN Property of Compute node Dynamically ,With out promote to property..
_________________
Thanks & Regards
Mahesh Mediboyina
WMB Developer |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Fri Nov 08, 2013 4:00 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
What you are asking for are two different things
Promoting the property is still a static setting. i.e. the setting is set before deployment
Changing the DSN dynamically is a runtime thing.
Both questions have been asked before and answered. Have you searched here for anything?
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| dogorsy |
| Posted: Fri Nov 08, 2013 4:01 am Post subject: |
|
|
Knight
Joined: 13 Mar 2013
Posts: 553
Location: Home Office
|
What does the documentation say ?
Read the compute node properties, see if they can be overridden using the LocalEnvironment. |
|
| Back to top |
|
|
| mahesh2069 |
| Posted: Fri Nov 08, 2013 4:31 am Post subject: |
|
|
Centurion
Joined: 26 Jun 2013
Posts: 103
|
I want to know how to set DSN dynamically , I know t one for static like promote property ,
But I have n't seen Changing DSN Name with help of Local Environment.
How To set the properties of Compute node like DSN dynamically ?
I want to change DSN Dynamically ,and Execute the logic with the compute node where we get Error having Unregistered DSN.
_________________
Thanks & Regards
Mahesh Mediboyina
WMB Developer |
|
| Back to top |
|
|
| dogorsy |
| Posted: Fri Nov 08, 2013 4:36 am Post subject: |
|
|
Knight
Joined: 13 Mar 2013
Posts: 553
Location: Home Office
|
If you are a WMB developer as you claim, you should know what is possible and what is not. You should also know how to search and read the documentation.
As smdavies99 said
| Quote: |
| Both questions have been asked before and answered. Have you searched here for anything? |
|
|
| Back to top |
|
|
| mahesh2069 |
| Posted: Fri Nov 08, 2013 4:44 am Post subject: |
|
|
Centurion
Joined: 26 Jun 2013
Posts: 103
|
Yes , I go through it ,but that answer not suitable for my question. I mean I want to change DSN Name which is In the Compute Node as property.
In before I have given Wrong DSN , I need to override with DSN ,Which is declared in Failure Case . How to Change it ?
Is there any Ideas ? Please share your valuable thoughts..
_________________
Thanks & Regards
Mahesh Mediboyina
WMB Developer |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Fri Nov 08, 2013 4:51 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
In that case, fix the message flow that has the problem, re-test and deploy.
You have a clear coding/configuration error plus your test cases don't seem to be comprehensive enough to have tested this bit of the flow before release.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| Esa |
| Posted: Fri Nov 08, 2013 5:15 am Post subject: |
|
|
Grand Master
Joined: 22 May 2008
Posts: 1387
Location: Finland
|
| mahesh2069 wrote: |
I want to change DSN Dynamically ,and Execute the logic with the compute node where we get Error having Unregistered DSN. |
Have you considered registering the DSN?
 It's Friday afternoon here... |
|
| Back to top |
|
|
| mahesh2069 |
| Posted: Fri Nov 08, 2013 5:29 am Post subject: |
|
|
Centurion
Joined: 26 Jun 2013
Posts: 103
|
Sry guys , but I need to submit my Task End of this Day . So I am so hurry to find the solutions ,and Resolve my issue. If you do n't mine help me.
In first time I will give unregistered DSN , So it will give Error , After getting error in failure case I Need to Give Correct DSN Which is registered .
I need to override this Unregistered DSN , With registered DSN.
I want to know how we can override Compute Node's DSN Property with Registered DSN.
_________________
Thanks & Regards
Mahesh Mediboyina
WMB Developer |
|
| Back to top |
|
|
| dogorsy |
| Posted: Fri Nov 08, 2013 5:32 am Post subject: |
|
|
Knight
Joined: 13 Mar 2013
Posts: 553
Location: Home Office
|
| mahesh2069 wrote: |
Sry guys , but I need to submit my Task End of this Day . So I am so hurry to find the solutions ,and Resolve my issue. If you do n't mine help me.
In first time I will give unregistered DSN , So it will give Error , After getting error in failure case I Need to Give Correct DSN Which is registered .
I need to override this Unregistered DSN , With registered DSN.
I want to know how we can override Compute Node's DSN Property with Registered DSN. |
So, you are asking the members of this forum to do your job. That is not very professional.
If you cannot find the answer, go to your team leader/manager and say that you need help and/or some formal education.
And ask for more time to complete the task. |
|
| Back to top |
|
|
| mahesh2069 |
| Posted: Fri Nov 08, 2013 5:45 am Post subject: |
|
|
Centurion
Joined: 26 Jun 2013
Posts: 103
|
Hello dogorsy ,
Please Excuse me Mr.dogorsy , Please do not misunderstand. Is there any ideas share with us, Thank you dogorsy.
_________________
Thanks & Regards
Mahesh Mediboyina
WMB Developer |
|
| Back to top |
|
|
| dogorsy |
| Posted: Fri Nov 08, 2013 5:47 am Post subject: |
|
|
Knight
Joined: 13 Mar 2013
Posts: 553
Location: Home Office
|
| mahesh2069 wrote: |
Hello dogorsy ,
Please Excuse me Mr.dogorsy , Please do not misunderstand. Is there any ideas share with us, Thank you dogorsy. |
yes, I have already told you.
| Quote: |
go to your team leader/manager and say that you need help and/or some formal education.
And ask for more time to complete the task. |
|
|
| Back to top |
|
|
| Esa |
| Posted: Fri Nov 08, 2013 5:48 am Post subject: |
|
|
Grand Master
Joined: 22 May 2008
Posts: 1387
Location: Finland
|
| mahesh2069 wrote: |
In first time I will give unregistered DSN , So it will give Error |
Why wouldn't you give a registered DSN to start with?
Do you have a requirement to play with unregistered DSN's?
Connecting to just any datasource that doesn't give Unregistered DSN exception will just bring you to the next problem: YouAreConnectedToWrongDatabaseException |
|
| Back to top |
|
|
| mahesh2069 |
| Posted: Fri Nov 08, 2013 5:53 am Post subject: |
|
|
Centurion
Joined: 26 Jun 2013
Posts: 103
|
When I will give registered DSN , If tht Database of that Registered DSN Fail , I Need to override another Database's Register DSN . So I need to override DSN which is Down , with Another Database 's Registered DSN in Compute Node's DSN Property.
_________________
Thanks & Regards
Mahesh Mediboyina
WMB Developer |
|
| Back to top |
|
|
|
|
