Re: Debugging an SQL UDF

[Luis Rodriguez <luisro58@xxxxxxxxx>]

James,

I think that they are case-sensitive. Try doing an EVAL *MYFUNC.MYVAR .

Regards,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries
--



On Wed, Apr 20, 2011 at 2:02 PM, James Lampert <jamesl@xxxxxxxxxxxxxxxxx>wrote:

> Charles Wilt wrote:
> > What version?  Works fine for me at v5r4
> >
> > create function cmwtest ( )
> > returns char(1)
> > language sql
> > set option dbgview = *SOURCE
> > begin
> >   return 'A';
> > end
>
> That works. Just didn't know where to put it.
>
> But now, when I open the debugger on it, in a service job, according to
> the instructions in the redbook, if I try to look at the variables, I
> get "Identifier does not exist."
>
> --
> JHHL
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.