| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Accessing Database using ESQL |
« View previous topic :: View next topic » |
| Author |
Message
|
| santy |
 Posted: Tue Nov 14, 2006 11:20 pm Post subject: Accessing Database using ESQL |
 |
|
Centurion
Joined: 03 Nov 2006
Posts: 141
|
Hi
I am trying to insert rows in to Database using ESQL.
I created Database EMPDB with ODBC connection.
then inside Computenode basic properties I gave data source name as EMPDB.
Created table EMPLOYEE
ESQL used is
UPDATE Database.EMPLOYEE AS T
SET ENAME = InputRoot.MRM.EMP.ENAME
WHERE T.ENAME = 'ABC';
I am not able to access database as it is throwing error :No data source with this name available
Please help
PS:DB2 8.1 , WMB 6 , MQ 6, WIN XP
thanks in advance,
santy |
|
| Back to top |
|
 |
| Edde |
| Posted: Tue Nov 14, 2006 11:56 pm Post subject: |
|
|
Acolyte
Joined: 01 Oct 2006
Posts: 67
Location: Moscow, Russia
|
Try to use forum search.
This problem was discussed recently, and more than once.
Hint: mqsisetdbparms will help. |
|
| Back to top |
|
|
| Mensch |
| Posted: Wed Nov 15, 2006 2:45 am Post subject: |
|
|
Disciple
Joined: 17 Jul 2005
Posts: 166
|
I Think you are missing Schema name ..
find out Table Schema name and search for Table Reference in WMB help
there you will get to know more about Schema name
also correct your ESQL to update Database.
_________________
Thanks and Regards ,
Mensch |
|
| 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
|
|
|
|
