Re: How Come

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

Bill - does it EVER run without the error? Someone else mentioned the 
order by using an expression - I don't believe it is supported, 
either - order by has to work against the result set, and that means 
you need column names of that result set - or the ordinals.

I think!
Vern

At 08:32 AM 2/20/2007, you wrote:

> P Decl_Saexpom    B
>
>       /FREE
>
>        EXEC SQL
>
>         Declare SAEXPOM
>
>         Cursor for
>
>          SELECT SUBSTR(SAEXPO,1,4) AS STORE,
>
>                 SUBSTR(SAEXPO,5,8) AS DATE,
>
>                 SUBSTR(SAEXPO,13,4) AS CODE,
>
>                 SUBSTR(SAEXPO,15,2) AS Codesfx,
>
>                 SUBSTR(SAEXPO,17,12) AS AMOUNT
>
>          FROM SAEXPOM
>
>          WHERE SUBSTR(SAEXPO,13,4)
> IN('1250','1260','1450','1460','2050','2060','2450','2460')
>
>            AND SUBSTR(SAEXPO,1,4) >= ' 100'
>
> SQL0104 Token SUBSTR was not valid. Valid tokens: ) ,
>
>          ORDER BY SUBSTR(SAEXPO,1,4);
>
>
>
>
>
> The above is strange and happens fairly regularly.  The statement is not
> in error and executes just fine.  How come?
>
> Thanks
>
> Bill Barnes
>
> Sr Analyst/Programmer
>
> The Pantry, Inc
>
> 919-774-6700
>
> ext 5211
>
>
>
> --
> This is the Websphere Development Studio Client for 
> iSeries  (WDSCI-L) mailing list
> To post a message email: WDSCI-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/wdsci-l
> or email: WDSCI-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/wdsci-l.