RE: SQL Whenver

[Buck Calabro <Buck.Calabro@xxxxxxxxxxxx>]

>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.

Hi Mark,
  The colon didn't sound right to me so I compiled this code.  Compiles just
fine.  I suggest you look to see if ERRHNDLR is defined as a procedure name
elsewhere.  Perhaps this is a side-effect of some other errors?  The last
time I used WHENEVER was on some RPG III code in 1999, and that was for a
test.  I just check SQLSTT now.
  --buck