Re: Can you "debug" SQL procedures?

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

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.