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.



This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].