I must say, I use triggers in UD with no problems. When converting from
D3 to UD I had a hard time getting them to work. However, with useful
suggestions from several on this list I was able to get them working
properly. They turned out to be a bit more robust than the D3
triggers. I've been able to "debug" the trigger several times when
problems appeared, but haven't for a number of years as they work as
expected now.
The structure took a while to get my head around, but I simply have two
trigger programs (globally cataloged):
U2.MASTER.TRIGGER.D
U2.MASTER.TRIGGER.U
...which handle all delete and update triggers. Inside each program a
file is read that actually provides the trigger subroutines to CALL (via
a CALL @...). So, I can insert any subroutine as a trigger in any
account. These programs are cataloged locally. I don't remember any
problems debugging these subroutines.
Just a thought.
Bill
------------------------------------------------------------------------
----- Original Message -----
*From:* [email protected]
*To:* U2 Users List <[email protected]>
*Date:* 7/29/2013 6:24 AM
*Subject:* Re: [U2] [UV] Do you avoid TRIGGERS because of the difficulty
using DEBUG or RAID with them? Was: Universe Triggers
That and the expense of their usage.
Perry Taylor
Zirmed, Inc.
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Charles Stevenson
Sent: Friday, July 26, 2013 1:32 PM
To: U2 Users List
Subject: [U2] [UV] Do you avoid TRIGGERS because of the difficulty using DEBUG
or RAID with them? Was: Universe Triggers
How many people avoid using triggers BECAUSE of the virtual
impossibility of using RAID with Triggers?
On 7/26/2013 12:33 PM, Phil Walker wrote:
I won't be holding my breath Charles ;-)
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Charles Stevenson
Sent: Friday, 26 July 2013 9:22 p.m.
To: U2 Users List
Subject: Re: [U2] Universe Triggers
re. triggers & Raid, I could not agree with Phil more. Well said.
Come on, Rocket!
On 7/19/2013 1:32 AM, Phil Walker wrote:
Ken,
I am glad you raised the issue about debugging a program with a file which has
a trigger attached. I have been on to UV (Vmark/Ardent/IBM/Rocket for ages
about fixing this pushing for the ability to be able to step into the trigger
code, but at a VERY MINIMUM being able to debug the program and perform the
write on the file, and in effect step over the trigger subroutine and carry on
debugging. The issue is the trigger subroutine cannot support input, so what UV
have done is basically say you are using the debugger so you are inputting
debug commands so you will abort. They need to turn this restriction off for
debugging so that either of the above two scenarios is supported.
In a Microsoft world I can debug anything through the connected world of
web/databases etc......
Have had no feedback from UV
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Ken Ford
Sent: Friday, 19 July 2013 9:48 a.m.
To: [email protected]
Subject: Re: [U2] Universe Triggers
Dan,
In addition to the other responses you have received, I suggest the following:
1. Have one master file trigger subroutine (globally catalogued) that calls
subroutines (locally catalogued) tailored to individual files. This means you
don't have to stop and restart Universe when a new trigger is required or a
change to an existing one. If the master subroutine changes, you do have to
restart Universe.
2. Use a control record that records the subroutine name and state of the
trigger for each file having a trigger.
3. Use a program to change the state of a trigger, using the control records in
2 above.
4. Make sure all background processes that have a file with a trigger open are
logged out when recompiling the subroutine for that file trigger.
5. Remember that you can't do anything to a file with an active trigger whilst
in the RAID debugger (it will crash). Rather, if you are testing a file
trigger subroutine, drop the trigger and use a trigger testing program that
calls the subroutine after taking a copy of the record being changed, pausing
whilst you change it in another session, and then resuming, calling the
subroutine.
If you would like samples of any of the software mentioned above, let me know,
and I can send them to you.
Regards,
Ken Ford
Universe Software Developer
t 07 3013 8605 | f 07 3002 8400
e [email protected] | w firstmac.com.au
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
CONFIDENTIALITY NOTICE: This e-mail message, including any
attachments, is for the sole use of the intended recipient(s)
and may contain confidential and privileged information. Any
unauthorized review, use, disclosure or distribution is
prohibited. ZirMed, Inc. has strict policies regarding the
content of e-mail communications, specifically Protected Health
Information, any communications containing such material will
be returned to the originating party with such advisement
noted. If you are not the intended recipient, please contact
the sender by reply e-mail and destroy all copies of the
original message.
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
