MQSeries.net :: View topic - Alternative for PASSTHRU in Broker 5?

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 » Alternative for PASSTHRU in Broker 5?

Alternative for PASSTHRU in Broker 5?

« View previous topic :: View next topic »

Author

Message

Posted: Tue Mar 04, 2008 9:53 pm Post subject: Alternative for PASSTHRU in Broker 5?

Acolyte

Joined: 21 Jul 2007
Posts: 64

Guys,

I need to select records from db table order by ID. My select stmt is something like
--> PASSTHRU('SELECT...... ORDER BY ID')

Unfortunately this function is not supported in V5. Please suggest any alternative for order by in V5. Thanks!!!!!!!

gregop

Posted: Wed Mar 05, 2008 1:50 am Post subject:

Voyager

Joined: 24 Nov 2006
Posts: 81

What type of database do you have ?

PASSTHRU will run any SQL supported by the database, PASSTHRU('SELECT * FROM A ORDER BY A') should work fine on most/all databases supported by the broker.

ORDER BY isn't supported if you make your select without PASSTHRU. E.g.

SET OutputRoot.XMLNS.Data[] = Select * from Database.A ORDER BY X

mgk

Posted: Wed Mar 05, 2008 2:24 am Post subject:

Padawan

Joined: 31 Jul 2003
Posts: 1642

PASSTHRU works on all versions of the broker since 2.0
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions.

Last edited by mgk on Wed Mar 05, 2008 2:25 am; edited 1 time in total

mgk

Posted: Wed Mar 05, 2008 2:24 am Post subject:

Padawan

Joined: 31 Jul 2003
Posts: 1642

Please excuse my over eager mouse clicking causing a double posting...

_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Alternative for PASSTHRU in Broker 5?

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