Re: Debugging RPGIV program used by SQL UDF (was Extraction problem)

[Buck <kc2hiz@xxxxxxxxx>]

Planet of the Apes wrote:
> I used STRDBG to set a breakpoint in the RPGIV program, then used STRSQL 
> to execute the UDF, but it wouldn't stop at the breakpoint.  

Yeah, that's because there's threading involved.  The FAQ describes how 
to debug a UDF http://faq.midrange.com/data/cache/185.html but I guess 
the same thing is in the IT Jungle article.  I apologise for not being 
very clear.

> BTW, I'm using WDSC these days and I also tried without success to debug 
> it by setting a Service Entry Point from WDSC to debug it.  I was able 
> to set an SEP on the program, but it wouldn't start debugging the 
> program in WDSC when I was using STRSQL on the green-screen session.  I 
> guess I need a tutorial in debugging with WDSC...

WDSC 7.0.0.2 here.  I opened the RPGLE program that makes up the 
function, but that's because I wanted to edit it anyway.  In the 
filter/navigator view, right click the member name and choose 'Debug 
(Service entry)' then 'Set service entry point'  Once I get the 
acknowledgment that the SEP was added, I go to a green screen or the 
iNav SQL script panel and run the SQL that invokes the UDF.  WDSC takes 
a moment to switch to the debug perspective and then shows the RPG 
source.  F5 to step into, and if you're like me you'll accidentally 
press F11 a few times to look at a variable's contents. Hover the cursor 
is better because F11 tries to fire up my last Java mess for debugging...
  --buck