| Author |
Message
|
| Harshalw |
 Posted: Wed Aug 20, 2008 5:45 am Post subject: dynamic selection of database. |
 |
|
Voyager
Joined: 23 Jul 2008
Posts: 77
|
Hi,
I need to choose database at runtime. Is there any way we can do in Esql code. also can we run the command like "mqsisetdbparms" through esql code with the configurable parameters ?
Thanks
Harshalw |
|
| Back to top |
|
 |
| elvis_gn |
| Posted: Wed Aug 20, 2008 8:55 am Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi Harshalw,
Why do you need to run the command at runtime...run it beforehand and call which ever you need through the ESQL. Anyway you are allowed to call multiple databases(of the same type) through one single compute node.
Regards. |
|
| Back to top |
|
|
| Harshalw |
| Posted: Wed Aug 20, 2008 10:34 pm Post subject: |
|
|
Voyager
Joined: 23 Jul 2008
Posts: 77
|
I am using DB2 on AIX box. After certain period of time the password for AIX server revokes, which will fail my application. So for every password revoke or user id change i cannot change the code. I want code to login with the latest password and user id runtime dynamically. Like password and user id should be stored in some table/or file and i will connect to db2 using that password and user id. Is that possible through ESQL? if so , plz tell me how.
Thanks
harshalw |
|
| Back to top |
|
|
| fschofer |
| Posted: Thu Aug 21, 2008 1:56 am Post subject: |
|
|
Knight
Joined: 02 Jul 2001
Posts: 524
Location: Mainz, Germany
|
|
| Back to top |
|
|
| Harshalw |
| Posted: Thu Aug 21, 2008 3:37 am Post subject: |
|
|
Voyager
Joined: 23 Jul 2008
Posts: 77
|
another node is required for that. 
cant it be done in compute node using Esql ? |
|
| Back to top |
|
|
| fschofer |
| Posted: Thu Aug 21, 2008 3:49 am Post subject: |
|
|
Knight
Joined: 02 Jul 2001
Posts: 524
Location: Mainz, Germany
|
|
| Back to top |
|
|
|
|
