SQL Whenver

[MWalter@xxxxxxxxxxxxxxx]

Hello all,

Could someone let me in on the secret of using WHENEVER SQLERROR in a RPGLE
subprocedure. I have the following code:

     c/exec sql
     c+ WHENEVER SQLERROR GOTO ERRHNDLR
     c/end-exec

      .... Stuff that builds a data structure

c    c     ERRHNDLR      TAG
c    c                   eval      errorId = 'HWC0215'
     c                   eval      datacount = 0
     c                   return    *null


When I try to compile I get  a RNF7030 on the ERRHNDLR and an RNF7043
(Target is not a label) error.

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
/ \