| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| WMB:Using Database node How to insert 1 row. |
« View previous topic :: View next topic » |
| Author |
Message
|
| Jithesh shetty |
 Posted: Tue Oct 30, 2007 11:06 pm Post subject: WMB:Using Database node How to insert 1 row. |
 |
|
Acolyte
Joined: 30 Oct 2007
Posts: 51
|
hi,
iam using Oracle 10g databse(VMI databse name) for WMB.....
i wanted to insert one row to Employee table, using ESQL coding...can any one suggest me how to do that???????
jeethu |
|
| Back to top |
|
 |
| elvis_gn |
| Posted: Wed Oct 31, 2007 12:38 am Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi Jithesh shetty,
Use the Insert Statement available in the Infocenter or WMB pdfs.... 
Regards. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed Oct 31, 2007 4:02 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
OR use a DataInsert node.
OR use a Database ndoe.
OR use a Warehouse node.
OR use a Mapping node.
OR use MbSQLStatement in a Java compute node to execute the ESQL Insert.
OR use JDBC from in a Java Compute node.
In all cases, you'll want to read the documentation first, so you know what you're doing.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| mgk |
| Posted: Wed Oct 31, 2007 5:16 am Post subject: |
|
|
Padawan
Joined: 31 Jul 2003
Posts: 1642
|
And don't forget the poor Filter node as well 
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions. |
|
| 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
|
|
|
|
