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

[Bill <brobins3d@xxxxxxxxx>]

Peter Vidal wrote:
> 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)')  

Peter,

Whenever I've done grouping on a Select where there's a CASE statement, 
I've always restated the CASE statement in the Grouping and they've 
always worked.  Try replacing the ITNBR with the CASE statement.

Bill