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.