Re: SQL error codes

If I understand you correctly a simple call to "WRKMSGD MSGF(QSQLMSG)" on 
an AS/400 command line does the trick. You can position to the error-code 
in question. In your case it probably is SQL0204 ( "SQL", zero, two, zero, four 
) aposed to SQLO204 ( "SQLO", two, 
zero, four ).

I hope that helps you.
regards
        Marc Cent
______________________________

DAKOSY
Datenkommunikationssystem AG
Mattentwiete 2, 20457 Hamburg
mailto:cent@dakosy.de
______________________________





Glenn Holmer <gholmer@weycogroup.com>
Sent by: owner-java400-l@midrange.com
12.03.01 14:57
Please respond to JAVA400-L

 
        To:     Java400 mailing list <JAVA400-L@midrange.com>
        cc: 
        Subject:        SQL error codes


How do I find the error message that goes along with an SQL error code?
I have a user reporting

> JAVA.SQL. SQLEXCEPTION: (SQLO204) SLMPWD in COMMONALC type * FILE

and I am unable to reproduce the error myself.

--
____________________________________________________________
Glenn Holmer                          gholmer@weycogroup.com
Programmer/Analyst                       phone: 414.908.1809
Weyco Group, Inc.                          fax: 414.908.1601

+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to 
JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---


+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---