Re: How Come

Off the top of my head, isn't  "SUBSTRING" in SQL?

Well of course not, I just tested it with STRSQL,  both SUBSTR and
SUBSTRING worked.   Probably has something to do with the compilier.


Michael Schutte
Admin Professional
Bob Evans Farms, Inc.
We've built a better hotcake -- Stacked and Stuffed Hotcakes -- coming
January 11th!
For hotcake tips, interviews with our chefs and more, check out the Stacked
and Stuffed blog at http://imstuffed.blogspot.com



                                                                           
             "Bill Barnes"                                                 
             <bbarnes@thepantr                                             
             y.com>                                                     To 
             Sent by:                  <wdsci-l@xxxxxxxxxxxx>              
             wdsci-l-bounces@m                                          cc 
             idrange.com                                                   
                                                                   Subject 
                                       [WDSCI-L] How Come                  
             02/20/2007 09:32                                              
             AM                                                            
                                                                           
                                                                           
             Please respond to                                             
                 Websphere                                                 
                Development                                                
             Studio Client for                                             
             iSeries<wdsci-l@m                                             
               idrange.com>                                                
                                                                           
                                                                           




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.