Re: Can you "debug" SQL procedures?

Here is a brand new article written by Kent Milligan:
IBM Data Studio debugger and IBM DB2 for i
Graphically debug your SQL stored procedures and functions
http://www.ibm.com/developerworks/ibmi/library/i-debugger-db2-i/

May be it helps

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"

-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von Hoteltravelfundotcom
Gesendet: Thursday, 29.8 2013 22:30
An: Midrange Systems Technical Discussion
Betreff: Re: Can you "debug" SQL procedures?

IN SQL Server, there is ANjilab spy product. WHat it does is show you what
is happening on the server while your SQL Is running. This is as close to a
debugger as I have seen. You can stop it at will.


On Wed, Aug 28, 2013 at 1:58 PM, Vern Hamberg
<vhamberg@xxxxxxxxxxxxxxx>wrote:

I just googled "debug sql stored procedure iseries navigator" and
found this link, the first one here - and many others.

www.xaeigroup.com/download/file.php?id=51

----- Original Message -----
Do you mean a stored procedure or SQL User Defined Function?. Both can
be debugged by using SBREAK to set a breakpoint and then running the
SQL statement in another job.


On Wed, Aug 28, 2013 at 11:05 AM, Mike Wills <mike@xxxxxxxxxxxx> wrote:

I am working on my first more advance procedure and was wondering if
there is a way to debug a SQL procedure?

--
Mike Wills
http://mikewills.me
--
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.

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

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


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