MQSeries.net :: View topic - Select Query With Joins Using ESQL.

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 » Select Query With Joins Using ESQL.

Select Query With Joins Using ESQL.

« View previous topic :: View next topic »

Author

Message

SandiSan

Posted: Thu Jul 24, 2008 4:59 pm Post subject: Select Query With Joins Using ESQL.

Acolyte

Joined: 01 Apr 2006
Posts: 57
Location: Pune/India

Hi,

Can anyone pls let me know if we can issue select query with joins using ESQL. I don't want to go for Passthru.

Regards
Sandisan

AkankshA

Posted: Thu Jul 24, 2008 8:18 pm Post subject:

Grand Master

Joined: 12 Jan 2006
Posts: 1494
Location: Singapore

Yes........ You can....
_________________
Cheers

jeeth_m

Posted: Fri Jul 25, 2008 12:45 am Post subject:

Voyager

Joined: 21 Jan 2002
Posts: 93

well.. you may end up using passthru if your select query is complex.
otherwise if its a straightforward joins.. yes you can do it without passthru and i read some where it is more efficient if you dont use passthru.

more details here.
http://publib.boulder.ibm.com/infocenter/wmbhelp/v6r0m0/index.jsp

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Select Query With Joins Using ESQL.

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