| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Is it possible to sort SQL queries in ESQL? (WMQI2.1CSD2) |
« View previous topic :: View next topic » |
| Author |
Message
|
| Nyusser |
 Posted: Sun Oct 06, 2002 9:41 pm Post subject: Is it possible to sort SQL queries in ESQL? (WMQI2.1CSD2) |
 |
|
Apprentice
Joined: 02 Jul 2002
Posts: 48
|
Hi,
I tried to use SQL SELECT-statement with ORDER BY <attr> DESC, but ESQL reports error on this. SQL Statement works fine without ORDER BY <attr> DESC...
Is it really not possible to sort SQL queries in ESQL?
- Nyusser |
|
| Back to top |
|
 |
| kirani |
| Posted: Mon Oct 07, 2002 9:42 am Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
ORDER BY clause is not supported by SELECT ESQL, please try to use PASSTHRU ESQL statement instead.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| Nyusser |
| Posted: Thu Oct 10, 2002 1:20 am Post subject: |
|
|
Apprentice
Joined: 02 Jul 2002
Posts: 48
|
Once again. Thanks. 
Regs,
Nyusser |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
|
|
|
|
