MQSeries.net :: View topic - SORT BY IN ESQL select Query.

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 » SORT BY IN ESQL select Query.

SORT BY IN ESQL select Query.

« View previous topic :: View next topic »

Author

Message

pratikp.vasani

Posted: Tue Oct 18, 2011 9:43 pm Post subject: SORT BY IN ESQL select Query.

Novice

Joined: 04 Jul 2011
Posts: 11

Hi,
I was trying to use the SORT function in the Select query but i am getting some errors.
Which is the proper way to use the SORT function in ESQL.

ruchir

Posted: Tue Oct 18, 2011 10:45 pm Post subject:

Guest

Hi,

Posting your error or your query will help us too solve your issue.

fjb_saper

Posted: Tue Oct 18, 2011 10:58 pm Post subject:

Grand High Poobah

Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY

ESQL is different from SQL. There is no SORT or ORDER BY in ESQL.

_________________
MQ & Broker admin

lancelotlinc

Posted: Wed Oct 19, 2011 4:33 am Post subject:

Jedi Knight

Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA

You could use SORT within a stored procedure or in a ad-hoc SQL statement. The DB needs to perform the SORT.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » SORT BY IN ESQL select Query.

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