| Author |
Message
|
| pathipati |
 Posted: Mon Jun 18, 2007 7:56 pm Post subject: How to pass tnsname in to ESQL INSERT statement? |
 |
|
Master
Joined: 03 Mar 2006
Posts: 296
|
INSERT INTO Database.TABLE1(MSGDATA) VALUES (msgBitStream);
in to above statement what is the format to give serverName:portNumber:sid? (tnsname) |
|
| Back to top |
|
 |
| elvis_gn |
| Posted: Mon Jun 18, 2007 9:02 pm Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi pathipati,
And why would you like to give the tns details in the flow ? Do you expect it to change dynamically or something ? I don't think you can do that..Plz tell us your requirement...
Regards. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Tue Jun 19, 2007 3:40 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
All database access, except what you write yourself in a Java compute node, is done using ODBC.
In ODBC, the tnsname is saved in the datasource - and your code merely references the datasource name.
Welcome to Broker, please read the documentation... 
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| pathipati |
| Posted: Tue Jun 19, 2007 8:34 am Post subject: |
|
|
Master
Joined: 03 Mar 2006
Posts: 296
|
| the reason is I am expecting to pass in tns information to my message flow manually/dynamically. I don't have a requirement but I just want to make sure if I can do this or not. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Tue Jun 19, 2007 8:37 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
You can not dynamically create an ODBC datasource in Message Broker.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
|
|
