| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Using Database nodes in WMQI |
« View previous topic :: View next topic » |
| Author |
Message
|
| Oops |
 Posted: Sat Jan 31, 2004 5:50 am Post subject: Using Database nodes in WMQI |
 |
|
Newbie
Joined: 20 Jan 2004
Posts: 9
|
Hi,
Iam trying to insert data to a table in DB2 throuht WMQI.
Iam using the follwoing code in DataBase Node:
| Code: |
INSERT INTO Database.TEST(KEY,MSG) VALUES('AAA','BBBBB') ;
|
Where TEST is my table name and KEY and MSG are the fields.
The data base is not getting updated.
Please let me knwo if there are any configurations to be done other than the ODBC connection to the data base.
Thanks |
|
| Back to top |
|
 |
| Missam |
| Posted: Sat Jan 31, 2004 9:33 am Post subject: |
|
|
Chevalier
Joined: 16 Oct 2003
Posts: 424
|
| Which version of mqsi are you woking,did u check your ODBC connection,did u find any errors in you log. |
|
| Back to top |
|
|
| Oops |
| Posted: Sat Jan 31, 2004 8:04 pm Post subject: |
|
|
Newbie
Joined: 20 Jan 2004
Posts: 9
|
Hi,
Iam trying this in IBM WebSphere MQ Integrator Version 2.1.
And I have given the ODBC connectivity also.
Thanks |
|
| Back to top |
|
|
| kirani |
| Posted: Sat Jan 31, 2004 11:12 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Look for any error into Event viewer on the broker machine. Do you have MQInput's catch terminal attached? It'd be a good idea to look at the ExceptionList for error debugging.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| 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
|
|
|
|
