MQSeries.net :: View topic - PASSTHRU Function

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » PASSTHRU Function

PASSTHRU Function

« View previous topic :: View next topic »

Author

Message

psn

Posted: Fri Apr 01, 2005 12:52 am Post subject: PASSTHRU Function

Disciple

Joined: 30 Oct 2002
Posts: 193
Location: France

Hi,

I want to access another DB Table as a Broker DB Table with a PASSTHRU Function what must I do ?

Thanks

martinrydman

Posted: Fri Apr 01, 2005 2:02 am Post subject:

Centurion

Joined: 30 Jan 2004
Posts: 139
Location: Gothenburg, Sweden

I'm not sure I understand your question, but it seems you want to access a database table other than the Broker database tables, i.e. some application specific data. If this is the case then:

1. Create a new database and table(s). Don't mix app data with broker data in the same db
2. Create a ODBC data source for this new db
3. In the Compute node where you want to execute the PASSTHRU, set the Data Source parameter to the name of your ODBC data source
4. Exceute any SQL statement within single quoutes with PASSTHRU
5. Read up on PASSTHRU in the doc

If not, then please clarify your question

/Martin

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » PASSTHRU Function

Jump to:

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

Protected by Anti-Spam ACP