Joined: 05 Sep 2001 Posts: 3779 Location: Torrance, CA, USA
You will first need to setup odbc connection on your broker machine to Oracle db. For doing this you will have to change .odbc.ini file. Administrator maual talks about how to setup this file.
Bringup the properties dialog box for your database node and click on "Add" button in input/output pane. Select Database table and enter your ODBC DSN name and Table name in Data Source and Table Name fields respectively.
Write ESQL statement to operate on remote database in this node. _________________ Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
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