| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| SELECT SUM function |
« View previous topic :: View next topic » |
| Author |
Message
|
| N |
 Posted: Tue Apr 01, 2008 12:56 am Post subject: SELECT SUM function |
 |
|
Acolyte
Joined: 21 Jul 2007
Posts: 64
|
HI all,
I hava a weird case where the following esql working in message broker V6 but not in V5. From my understanding SUM function supported in V5.
Please help
SET Environment.Variables.total =
SELECT SUM(T.length) FROM Database.table AS T
WHERE T.code = '1234' |
|
| Back to top |
|
 |
| mgk |
| Posted: Tue Apr 01, 2008 2:46 am Post subject: |
|
|
Padawan
Joined: 31 Jul 2003
Posts: 1642
|
Well SELECT in V5 needs round brackets () around the SELECT for a start...
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Tue Apr 01, 2008 4:08 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Also, v5 is going out of support.
There's no reason to do anything with it, except migrate code FROM it, not TO it.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| N |
| Posted: Tue Apr 01, 2008 7:22 pm Post subject: |
|
|
Acolyte
Joined: 21 Jul 2007
Posts: 64
|
Guys,
Thanks. Migration will start soon  |
|
| 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
|
|
|
|
