Re: Debug SQL Trigger

[Jeff Young <jyoung0950@xxxxxxxxx>]

Thanks Mark.
I have resolved the problem.  It was a data issue in the file i was testing
in the WHEN clause.
The trigger logic is coded in SQL and calls a stored procedure (QSNDDTAQ).
I played around with the WHEN clause until I found my issue.

Jeff Young
Sr. Programmer Analyst

On Fri, Oct 9, 2015 at 7:56 AM, Mark Murphy/STAR BASE Consulting Inc. <
mmurphy@xxxxxxxxxxxxxxx> wrote:

> If the trigger is implemented as an RPGLE program or procedure, you can
> use SEP.
>
> Mark Murphy
> STAR BASE Consulting, Inc.
> mmurphy@xxxxxxxxxxxxxxx
>
>
> -----Jeff Young <jyoung0950@xxxxxxxxx> wrote: -----
> To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> From: Jeff Young <jyoung0950@xxxxxxxxx>
> Date: 10/07/2015 01:30PM
> Subject: Debug SQL Trigger
>
> Is there any way to debug an SQL Trigger?
> I have created an SQL Trigger that I feel should be calling a stored
> procedure on selected conditions, but it is not doing it.
> Is there any way I can see what it is doing so I can figure out where I
> went wrong?
>
> Jeff Young
> Sr. Programmer Analyst
> --
> 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.