Re: SQLSTATE 58004

[TAllen@xxxxxxxxxxxx]

It is always helpful to set the SHOWSQL variable to "YES" so you can see
the actual SQL statement being executed.  Often times seeing the statement
will help track down the syntax error.  Or you can paste the statement into
iNav or your favorite SQL client for debugging.

Thanks,
Todd Allen
EDPS
Electronic Data Processing Services
tallen@xxxxxxxxxxxx



                                                                           
             "Raul A. Jager                                                
             W."                                                           
             <raul@xxxxxxxxxx>                                          To 
             Sent by:                  Web Enabling the AS400 / iSeries    
             web400-bounces@mi         <web400@xxxxxxxxxxxx>               
             drange.com                                                 cc 
                                                                           
                                                                   Subject 
             2010-02-16 11:02          [WEB400] SQLSTATE 58004             
                                                                           
                                                                           
             Please respond to                                             
             Web Enabling the                                              
              AS400 / iSeries                                              
             <web400@midrange.                                             
                   com>                                                    
                                                                           
                                                                           




I have a NetData macro (source below) that was working fine during
several years, sudently, yesterday it failed with a SQLSTATE 58004 in
function listAsie(). The cause seems to be in the "WHERE" clause,
eliminating the and it works, eliminating the or also works (but the
report is not what I need).
I also tried to replace $(REMOTE_USER) with a constant, same error.
Temporary solution: I replaced the physical file with a view, and
eliminated the and.
Today I restored the original version: surprise, it works!!!
I can not reproduce the error, it went by itself, it may return when I
least want it.