RE: SQL WHENEVER

["Stoner, Bart -FWDC.CON" <Bart.Stoner@xxxxxxx>]

Try this:

        c/exec sql
        c+ WHENEVER SQLERROR GO TO :ERRHNDLR
        c/end-exec

My code is as follows and I know it works:

        c/exec sql WHENEVER SQLERROR GO TO EXIT


Bart
  
Phone: (260) 451-6449
E-mail: bart.stoner@itt.com 

-----Original Message-----
From: MWalter@hanoverwire.com [mailto:MWalter@hanoverwire.com] 
Sent: Monday, January 13, 2003 10:55 AM
To: rpg400-l@midrange.com
Subject: RE:SQL WHENEVER

the colon didn't help!


Thanks,

Mark


Mark Walter
Sr. Programmer/Analyst
Hanover Wire Cloth a div of CCX, Inc.
mwalter@hanoverwire.com
http://www.hanoverwire.com
717.637.3795 Ext.3040
/"\
\ /
 X
/ \


_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo.cgi/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

************************************ 
If this email is not intended for you, or you are not responsible for the
delivery of this message to the addressee, please note that this message may
contain ITT Privileged/Proprietary Information.  In such a case, you may not
copy or deliver this message to anyone.  You should destroy this message and
kindly notify the sender by reply email.  Information contained in this
message that does not relate to the business of ITT is neither endorsed by
nor attributable to ITT. 
************************************