Re: [U2] [UV] Do you avoid TRIGGERS because of the difficulty using DEBUG or RAID with them? Was: Universe Triggers

2013-08-27 Thread Hona, David
Yes, Chuck a typo in the release number and much less capable than SQL style triggers...so a backwards step too. But far less overhead and drama to setup/maintain... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf

Re: [U2] [UV] Do you avoid TRIGGERS because of the difficulty using DEBUG or RAID with them? Was: Universe Triggers

2013-08-06 Thread Charles Stevenson
@IDX.IOTYPE Thanks to a fellow u2-list member who mailed me privately. I think David Hona was maybe thinking of that, but it's available at 11.1, not 10.1. Chuck On 8/5/2013 6:23 PM, Perry Taylor wrote: Rocket added an @variable (don't recall the name of it) that tells which call is being

Re: [U2] [UV] Do you avoid TRIGGERS because of the difficulty using DEBUG or RAID with them? Was: Universe Triggers

2013-08-05 Thread Perry Taylor
Rocket added an @variable (don't recall the name of it) that tells which call is being made. Perry -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Saturday, August 03, 2013 9:40 AM To: U2

Re: [U2] [UV] Do you avoid TRIGGERS because of the difficulty using DEBUG or RAID with them? Was: Universe Triggers

2013-08-03 Thread Charles Stevenson
David, I didn't understand your 1st clause, Now that (from UV10.1) Index-based triggers are officially supported, By index-based triggers, I assume you mean the trick of indexing an I-descriptor that calls a subroutine that updates some other file, which is generally not the sort of

Re: [U2] [UV] Do you avoid TRIGGERS because of the difficulty using DEBUG or RAID with them? Was: Universe Triggers

2013-08-02 Thread Jacques G.
Trigger are useful to find programs that update files incorrectly.   When this happens,  I create a trigger that will create a sequential file with the content of SYSTEM(9001) on Universe in order to identify the chain of calling programs. From: Hona, David

Re: [U2] [UV] Do you avoid TRIGGERS because of the difficulty using DEBUG or RAID with them? Was: Universe Triggers

2013-08-01 Thread Hona, David
Now that (from UV10.1) Index-based triggers are officially supported, can these replace your SQL-based triggers? These have less functionality and less overhead, but that's the price you have to pay Can't say I had a chance to try it for myself...yet...! -Original Message- From:

Re: [U2] [UV] Do you avoid TRIGGERS because of the difficulty using DEBUG or RAID with them? Was: Universe Triggers

2013-08-01 Thread Phil Walker
That is not the point. Why should I have to do a workaround to get around something which should just work. I cannot see what would be so hard about allowing the debugging of programs which access a file with a trigger associated with it without aborting which UV currently does. That as a

Re: [U2] [UV] Do you avoid TRIGGERS because of the difficulty using DEBUG or RAID with them? Was: Universe Triggers

2013-07-29 Thread Perry Taylor
That and the expense of their usage. Perry Taylor Zirmed, Inc. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Friday, July 26, 2013 1:32 PM To: U2 Users List Subject: [U2] [UV] Do you avoid

Re: [U2] [UV] Do you avoid TRIGGERS because of the difficulty using DEBUG or RAID with them? Was: Universe Triggers

2013-07-29 Thread Bill Haskett
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

Re: [U2] [UV] Do you avoid TRIGGERS because of the difficulty using DEBUG or RAID with them? Was: Universe Triggers

2013-07-29 Thread Israel, John R.
We use this same concept. The triggers themselves are globally cataloged, but all they do is check a table then based on the file in question, call a 2nd locally (DIRECT) subroutine. Debugging is simple for us and never clobbers the live code when developing in a test environment on the same

Re: [U2] [UV] Do you avoid TRIGGERS because of the difficulty using DEBUG or RAID with them? Was: Universe Triggers

2013-07-26 Thread Phil Walker
I know we use them, but whenever one of the programmers wants to debug a program they take them off, which causes us other problems as we have processes which rely on the trigger output. This would be my biggest beef with UV at the moment. -Original Message- From: