MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » April 2008

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



fixed

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.


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





Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact