Re: SQLSTATE 58004

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.