Simple debugging of procedures?

Hello,

Is there a simple way to debug DB2 SQL procedures, such as: which branch
of a conditional construct was chosen, what value did a counter reach,
etc, _without_ installing some big, complicated IDE?

My question could maybe be rephrased as "is there a way to perform printf-
style debugging in DB2 SQL procedures?"

If not: I'm considering creating a C-based UDF which logs arbitrary
strings to syslog, so that a SQL procedure can inform the surroundings of
its state during development.

--
Troels

On Sep 5, 11:17 pm, Troels Arvin wrote:
> Hello,
>
> Is there a simple way to debug DB2 SQL procedures, such as: which branch
> of a conditional construct was chosen, what value did a counter reach,
> etc, _without_ installing some big, complicated IDE?
>
> My question could maybe be rephrased as "is there a way to perform printf-
> style debugging in DB2 SQL procedures?"
>
> If not: I'm considering creating a C-based UDF which logs arbitrary
> strings to syslog, so that a SQL procedure can inform the surroundings of
> its state during development.
>
> --
> Troels

I don't know if Serge's SQL PL/PL/SQL profiler would be of use:
http://www.google.com/url?sa=D&q=https://www.ibm.com/developerworks/my...eloperw

(I hope this link works, otherwise he had posted it a short while
ago.)

What else comes to my mind is a debug table and a debug function,
something like insert into dbg values (current timestamp, message).

PL/SQL should have a debug function built in if you're on V9.7.

Sorry, mainly guesses here.