RE: EXCSQLSTM command: Keyword ORDER not expected. Valid tokens: ) UNIONEXCEPT.

Thanks Mark / Eric for your prompt response:

I tried:

(SELECT DISTINCT +
''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'' +
ORDER BY ITNBR)')

But I sitll have the error message:

Message ID . . . . . . : SQL0199 Severity . . . . . . . : 30
Message type . . . . . : Diagnostic
Date sent . . . . . . : 04/10/08 Time sent . . . . . . : 11:02:07


Message . . . . : Keyword ORDER not expected. Valid tokens: ) UNION
EXCEPT.
Cause . . . . . : The keyword ORDER was not expected here. A syntax
error
was detected at keyword ORDER. The partial list of valid tokens is )
UNION
EXCEPT. This list assumes that the statement is correct up to the
unexpected
keyword. The error may be earlier in the statement but the syntax of
the
statement seems to be valid up to this point.
Recovery . . . : Examine the SQL statement in the area of the specified

keyword. A colon or SQL delimiter may be missing. SQL requires reserved

words to be delimited when they are used as a name. Correct the SQL
statement and try the request again.


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

"The wisest mind has something yet to learn."
George Santayana (1863-1952)

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

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.


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