| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| ESQL |
« View previous topic :: View next topic » |
| Author |
Message
|
| dilep |
 Posted: Fri Sep 12, 2008 10:58 pm Post subject: ESQL |
 |
|
Apprentice
Joined: 27 Nov 2006
Posts: 40
|
Hi,
I want to use " DISTINCT " in ESQL.
But It showing error. DISTINCT is not supported. Can anyone know alternate to this "DISTINCT" keyword.
Thanks  |
|
| Back to top |
|
 |
| bower5932 |
| Posted: Sat Sep 13, 2008 6:20 am Post subject: |
|
|
Jedi Knight
Joined: 27 Aug 2001
Posts: 3023
Location: Dallas, TX, USA
|
|
| Back to top |
|
|
| elvis_gn |
| Posted: Sat Sep 13, 2008 11:55 pm Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi dilep,
Are you doing a SELECT with DISTINCT ? If yes, then it's not supported...unless you do a passthru ofcourse
Regards. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Sun Sep 14, 2008 10:09 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
However a little bit further down that page:
| Quote: |
Differences from the SQL standard
ESQL SELECT differs from database SQL SELECT in the following ways:
* ESQL can produce tree-structured result data
* ESQL can accept arrays in SELECT clauses
* ESQL has the THE function and the ITEM and INSERT parameters
* ESQL has no SELECT ALL function in this release
* ESQL has no ORDER BY function in this release
* ESQL has no SELECT DISTINCT function in this release
* ESQL has no GROUP BY or HAVING parameters in this release
* ESQL has no AVG column function in this release
|
Just because it is a reserved word in ESQL does not mean it is supported in the traditional sense. It might just mean, and we can all hope here, that it will be supported in some future release... 
_________________
MQ & Broker admin |
|
| 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
|
|
|
|
