EXCSQLSTM command: Keyword ORDER not expected. Valid tokens: ) UNION EXCEPT.

[Peter Vidal <Peter_Vidal@xxxxxxxx>]

Hi list:

I am using the EXCSQLSTM command to execute SQL stuff within CL's.  I am 
developing one today, as follows.

EXCSQLSTM  SQLSTM('INSERT INTO WHCON/DUPITMWRK +  
(SELECT  +  
''TIM'' AS LOC, +  
''MG'' AS ENV, +  
CASE +  
 WHEN SUBSTR(ITNBR,1,1) = ''T'' THEN ITNBR +  
 WHEN SUBSTR(ITNBR,1,1) <> ''T'' AND SUBSTR(ITNBR,15,1) = '' '' + 
              THEN ''T''||SUBSTR(ITNBR,1,14) +
 WHEN SUBSTR(ITNBR,15,1) <> '' '' THEN ITNBR +  
END AS ITEM  +  
FROM ITMRVA WHERE SUBSTR(STID,1,1) = ''T'' +  
GROUP BY ITNBR ORDER BY ITNBR)')  

However, I am having this error:
Keyword ORDER not expected. Valid tokens: ) UNION EXCEPT. 

I a trivial error but I can't see the issue.  If I remove the GROUP BY 
.... ORDER BY .... parts, it works.

Thanks in advance,


PETER VIDAL 
MAPICS IT TECHNICAL SUPPORT TEAM / SR SYSTEM ANALYST 
10540 Ridge Rd., Suite 203, New Port Richey, FL 34654-5111
Tel:727-849-9999, x2414 Fax:727-815-3120
WWW.PALL.COM 

"I can't understand why people are frightened of new ideas. I'm frightened 
of the old ones."
John Cage (1912-1992)

--------------------------------------------------------------------------------

Attention:

This communication may contain information that is confidential,
privileged and/or exempt from disclosure under applicable law.  
If you are not the intended recipient, please notify the sender 
immediately and delete the original, all attachments, and all 
copies of this communication.


--------------------------------------------------------------------------------