of
web/databases etc..
Have had no feedback from UV
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ken Ford
Sent: Friday, 19 July 2013 9:48 a.m.
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Universe
I won't be holding my breath Charles ;-)
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] 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
Trigger program will bomb out.
George
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mark Eastwood
Sent: Thursday, July 18, 2013 8:33 AM
To: U2 Users List
Subject: Re: [U2] Universe Triggers
Yes. Check out
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
...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ken Ford
Sent: Friday, 19 July 2013 9:48 a.m.
To: u2-users@listserver.u2ug.org
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
FYI the best doco on using triggers is in Chapter 5 of the Universe SQL
Reference pdf. It's pretty comprehensive.
Regards.
-Original Message-
AIX 5.3 UV 10.2Universe
I want to put a trigger on a file to send an email message then a new
item is written. I have read the (very
.
David A. Green
(480) 813-1725
DAG Consulting
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny
Sent: Friday, July 30, 2010 12:47 PM
To: U2 Users List
Subject: Re: [U2] Universe Triggers
Thank you all
...@listserver.u2ug.org] On Behalf Of Jeff Schasny
Sent: Friday, July 30, 2010 12:47 PM
To: U2 Users List
Subject: Re: [U2] Universe Triggers
Thank you all.
After much putzing with the various parts involved it is beginning to
look like my original plan of having an email message sent when someone
adds a new record
Your subroutine has to be globally cataloged - nothing else will work.
The syntax of the create trigger that works for me is this:
CREATE TRIGGER BEFORE_INSERT BEFORE INSERT ON (FILE NAME) FOR EACH ROW
CALLING *(subroutine name)
BEFORE_INSERT - name I gave my trigger - can be anything you want
Subject: Re: [U2] Universe Triggers
Thank You.
Now I need to drop the trigger and re create it. What is the drop
trigger syntax? Is all this actually documented somewhere?
Barry Rutherford wrote:
Your subroutine has to be globally cataloged - nothing else will work.
The syntax of the create
Thank You.
Now I need to drop the trigger and re create it. What is the drop
trigger syntax? Is all this actually documented somewhere?
Barry Rutherford wrote:
Your subroutine has to be globally cataloged - nothing else will work.
The syntax of the create trigger that works for me is this:
So far so good. Trigger installed. Trigger blows up. My trigger program
calls the *MAIL.SEND routine (which works when called from other
programs in this account) which is apparently blowing up when attempting
to write an item to the current directory (UFD) at line 214.
Anyone have a guess on
Before any WRITE, you must do a READU first
Mark
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny
Sent: Friday, July 30, 2010 11:47 AM
To: U2 Users List
Subject: Re: [U2] Universe Triggers
So far so
Lock the record before you write it.
Henry Unger
Sent from my iPad
On Jul 30, 2010, at 2:47 PM, Jeff Schasny jscha...@gmail.com wrote:
So far so good. Trigger installed. Trigger blows up. My trigger program calls
the *MAIL.SEND routine (which works when called from other programs in this
Thank you all.
After much putzing with the various parts involved it is beginning to
look like my original plan of having an email message sent when someone
adds a new record to this file is not to be. Apparently executing an
SH verb in a trigger program is not going to happen (Verb SH
How real-time does it need to be? Could you write them to a queue file and
have a small batch process pick them up and email them?
Rob
Robert F. Porter, MCSE, CCNA, ZCE
Lead Sr. Programmer / Analyst
Laboratory Information Services
Ochsner Health System
This transmission (including any
] On Behalf Of Jeff Schasny
Sent: Friday, July 30, 2010 12:47 PM
To: U2 Users List
Subject: Re: [U2] Universe Triggers
Thank you all.
After much putzing with the various parts involved it is beginning to
look like my original plan of having an email message sent when someone
adds a new record
Subject: Re: [U2] Universe Triggers
Thank you all.
After much putzing with the various parts involved it is beginning to
look like my original plan of having an email message sent when someone
adds a new record to this file is not to be. Apparently executing an
SH verb in a trigger program
] On Behalf Of Jeff Schasny
Sent: Friday, July 30, 2010 3:47 PM
To: U2 Users List
Subject: Re: [U2] Universe Triggers
Thank you all.
After much putzing with the various parts involved it is beginning to
look like my original plan of having an email message sent when someone
adds a new record
I was wondering if that's what you're up to.
I'm not at my computer, but try PHANTOMing it.
Henry Unger
Sent from my iPad
On Jul 30, 2010, at 3:48 PM, Jeff Schasny jscha...@gmail.com wrote:
Thank you all.
After much putzing with the various parts involved it is beginning to look
like my
-
From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] On Behalf Of Barry Rutherford
Sent: Saturday, 31 July 2010 8:01 a.m.
To: U2 Users List
Subject: Re: [U2] Universe Triggers
Have the subroutine that's called from your trigger routine write a
record
To: U2 Users List
Subject: Re: [U2] Universe Triggers
Thank You.
Now I need to drop the trigger and re create it. What is the drop
trigger syntax? Is all this actually documented somewhere?
Barry Rutherford wrote:
Your subroutine has to be globally cataloged - nothing else will work.
The syntax
] On Behalf Of Hona, David
Sent: Tuesday, November 10, 2009 12:37 AM
To: 'U2 Users List'
Subject: Re: [U2] Universe Triggers
Did you do a sanity check (on your system/UV setup - not you:))- being a
Windows platform check- no real-time anti-virus scanner is in operation on
every file modification
To: 'U2 Users List'
Subject: Re: [U2] Universe Triggers
Phil,
This appears to be a Windows bug. I ran my test program on a Universe 10.3
AIX box and it also took just 2 seconds.
Does anyone know if this bug is scheduled for resolution?
Thanks everyone, for all the help
Curt Stewart
TRI-SYS
] On Behalf Of Kevin King
Sent: Saturday, October 31, 2009 11:25 PM
To: U2 Users List
Subject: Re: [U2] Universe Triggers
Crazy thought... Could it have anything to do with the VOC being too small?
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http
Universe 10.3.1 RHEL 4.x and 10.1.13 Dec Alpha
-Original Message-
From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] On Behalf Of Curt Stewart
Sent: Saturday, 31 October 2009 5:46 p.m.
To: 'U2 Users List'
Subject: Re: [U2] Universe Triggers
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of phil walker
Sent: Saturday, October 31, 2009 1:05 AM
To: U2 Users List
Subject: Re: [U2] Universe Triggers
Universe 10.3.1 RHEL 4.x and 10.1.13 Dec Alpha
-Original
Crazy thought... Could it have anything to do with the VOC being too small?
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
is the trigger program doing any file opens? That would probably be your slow
down.
I've not tried to setup a common with any of the triggers I've setup, since the
number
of writes has been minimal for us (maybe 5 per hour maximum).
George
-Original Message-
From:
Gallen
Sent: 30 October 2009 15:38
To: U2 Users List
Subject: Re: [U2] Universe Triggers
is the trigger program doing any file opens? That would probably be your
slow down.
I've not tried to setup a common with any of the triggers I've setup,
since the number
of writes has been minimal for us (maybe 5
: Friday, October 30, 2009 10:38 AM
To: U2 Users List
Subject: Re: [U2] Universe Triggers
is the trigger program doing any file opens? That would probably be your
slow down.
I've not tried to setup a common with any of the triggers I've setup, since
the number of writes has been minimal for us (maybe 5
List'
Subject: Re: [U2] Universe Triggers
The speed issue is not in the subroutine itself. I tried a subroutine that
did nothing, just a return and the process takes 25 seconds compared to 2
seconds with out a trigger. My main trigger subroutine is using a common
for the file opens and that did
List'
Subject: Re: [U2] Universe Triggers
Curt,
We run Web applications a 25 second delay would be a death march for our
staff with the users pointing things at us. This is a known Universe issue
and to be fixed on a later release according the folks at U2 University.
We wrote our own auditing
-
From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] On Behalf Of Curt Stewart
Sent: Saturday, 31 October 2009 6:45 a.m.
To: 'U2 Users List'
Subject: Re: [U2] Universe Triggers
Thanks Doug,
That's pretty much the conclusion I came to after I ran my test
...@listserver.u2ug.org] On Behalf Of phil walker
Sent: Friday, October 30, 2009 5:39 PM
To: U2 Users List
Subject: Re: [U2] Universe Triggers
Check your file sizes out or your logic, because I experience nothing like
this still subsecond responses, and we use triggers for auditing/data
quality
the trigger as well
(perhaps it does now days, I can't check at the moment).
Regards,
David
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Susan Joslyn
Sent: Wednesday, 3 December 2008 12:16 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Universe
Hello Susan,
It seems that the SetDiagnostics() is a Function, you must use
VAR=SetDiagnostics('errtxt')
(I have not tested it into a trigger set on a non-SQL file !)
If I want to refuse the update into the trigger, I make : newrec = oldrec.
This don't change the record and don't crash the
-u2-
[EMAIL PROTECTED] De la part de Susan Joslyn
Envoyi : mardi 2 dicembre 2008 14:16
@ : u2-users@listserver.u2ug.org
Objet : Re: [U2] Universe triggers (still more)
Thanks to the folks who gave me info on Unidata triggers. I've had
those
implemented for years and they do work very
PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Susan Joslyn
Sent: Wednesday, 3 December 2008 2:16 a.m.
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Universe triggers (still more)
Thanks to the folks who gave me info on Unidata triggers. I've had
those
implemented for years and they do work
quote who='Susan Joslyn' date='Monday 01 December 2008'
Hi everyone,
I have the triggers working - yay! Thanks Manu! - but now I'm to the next
step, and of course stumbling again! My program sets a flag when it wants
to disallow the write that called the trigger. The manual seems to
Susan:
To expand further on Jeff's comment, the EXECSTAT variable is part of the
CALL arguements list. For instance, in UniData an update trigger might look
like:
001 SUBROUTINE U2.MASTER.TRIGGER.U ( ExecStat, DictFlag, atFILENAME, atID,
atRECORD )
The following table
Susan:
To expand further on Jeff's comment, the EXECSTAT variable is part of
the CALL arguements
list. For instance, in UniData an update trigger might look like:
001 SUBROUTINE U2.MASTER.TRIGGER.U ( ExecStat, DictFlag, atFILENAME, atID,
atRECORD )
The following table describes each
Setdiagnostics is a function which works by adding an error condition
message into the SQL error stack. A trigger program comes from the SQL
side of UV and runs within a transaction boundary, when the
setdiagnostics() function is used it will cause the trigger to go into
rollback mode on return
Manu,
You are a life-saver! Thank you! I didn't know about $OPTIONS PICK and
that truly solves the problem!
Which took me to the next problem. The trigger program appears to be much
more rigorous about record locks. That's fine for code that I can get to,
but it announces that I don't have
d'origine-
De : [EMAIL PROTECTED] [mailto:owner-u2-
[EMAIL PROTECTED] De la part de Susan Joslyn
Envoyi : mercredi 26 novembre 2008 11:26
@ : u2-users@listserver.u2ug.org
Objet : RE: [U2] Universe triggers + SB+
Manu,
You are a life-saver! Thank you! I didn't know about $OPTIONS PICK
@listserver.u2ug.org
Objet : RE: [U2] Universe triggers + SB+
Manu,
You are a life-saver! Thank you! I didn't know about $OPTIONS PICK
and
that truly solves the problem!snip
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
table are taken up
by an array.
Cheers,
Wol
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Manu Fernandes
Sent: 26 November 2008 12:47
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Universe triggers + SB+$ OPTIONS PICK
Hi,
About $OPTIONS PICK,
Yes
15:48
CB : u2-users@listserver.u2ug.org
ObjetB : RE: [U2] Universe triggers + SB+$ OPTIONS PICK
Does the common contain dimensioned arrays? Quite likely, I would have
thought.
And that would be why you need OPTIONS PICK. Ideal-flavour UV uses PI-
style arrays which have an element (0
Hi,
Do you use the $OPTIONS PICK into the basic code before INCLUDE DMSKELCODE
COMMON ?
My two pence.
Manu
-Message d'origine-
De : [EMAIL PROTECTED] [mailto:owner-u2-
[EMAIL PROTECTED] De la part de Susan Joslyn
Envoyi : mardi 25 novembre 2008 18:10
@ :
snip
Ray, let's not talk about huge and (formerly) little known security
flaws in UV now... :)
/snip
Why not? It's the little known security flaws that'll get you... It
doesn't matter if it's Windows, Oracle, Aix or UniVerse... the more
people know, the more they can guard against.
---
In message [EMAIL PROTECTED], Ken Wallis
[EMAIL PROTECTED] writes
UniData has a VOC_READONLY environment variable which can be set that allows
it to run successfully in a directory where the VOC has no write permission.
Perhaps UniVerse has the same or similar.
Bear in mind the OP of this
You can even write to the VOC if you don't have write permission to the file.
Hint: usd runs with superuser privileges.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
Ray, let's not talk about huge and (formerly) little known security
flaws in UV now... :)
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ray Wurlod
Sent: Tuesday, 21 October 2008 12:44 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Universe
I bet you I can write to the VOC unless I do not have write permissions
to the file.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Susan Joslyn
Sent: Friday, 17 October 2008 1:45 a.m.
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Universe Triggers
In my IBM Administering Universe from Unix manual, Chapter 5 System
Security, in section 5-8, it deals with VOC file security issues and
Security Subroutines using Remote pointers and a call to a 'security'
subroutine.
It isn't much doco to go on but it is what we based our VOC security
, you really can't. I can explain in more detail how I did it for
PRC if you like - but there are plenty of ways to do it - just read up on
the remote VOC.
Susan
Date: Wed, 15 Oct 2008 13:40:20 +0100
From: Anthony Youngman [EMAIL PROTECTED]
Subject: RE: [U2] Universe Triggers
But IF you can
PROTECTED] On Behalf Of Susan Joslyn
Sent: 15 October 2008 12:36
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Universe Triggers
David,
With the use of remote voc you really can prevent by-pass of wrapped TCL
commands. Completely, unequivocably.
Regards,
Susan Joslyn
SJ+ Systems Associates, Inc
,
Susan Joslyn
SJ+ Systems Associates, Inc.
PRC(r) Real software configuration management for U2!
--
Date: Wed, 15 Oct 2008 08:26:00 +1100
From: Hona, David S [EMAIL PROTECTED]
Subject: RE: [U2] Universe Triggers
You can by-pass them if you can update the VOC.
---
u2
From: Hona, David S [EMAIL PROTECTED]
Subject: RE: [U2] Universe Triggers
You can by-pass them if you can update the VOC.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
PROTECTED] [mailto:[EMAIL PROTECTED]
] On Behalf Of Susan Joslyn
Sent: 15 October 2008 12:36
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Universe Triggers
David,
With the use of remote voc you really can prevent by-pass of
wrapped TCL
commands. Completely, unequivocably.
Regards,
Susan
,
Susan
--
Date: Mon, 13 Oct 2008 08:00:54 -0400
From: Israel, John R. [EMAIL PROTECTED]
Subject: RE: [U2] Universe Triggers
There is still a hole to the wrapper approach.
Assuming you are trying to catch folks that use the ED (or AE) command, we
have to assume
You can by-pass them if you can update the VOC.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Susan Joslyn
Sent: Tuesday, 14 October 2008 10:12 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Universe Triggers
Both Universe and Unidata have
.
Of course, the wrapper is also much easier thing to install and
configure, so worth considering anyway.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of David Webster
Sent: Monday, 13 October 2008 3:51 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2
Dayton Superior Corporation
721 Richard St.
Dayton, OH 45342
937-866-0711 x44380
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Webster
Sent: Monday, October 13, 2008 12:51 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Universe Triggers
Hi Kate
Yep - pretty much.
1 - Globally cattledog the subprograms - otherwise it could crash your
update
2- If the subs change - recattledog them and they will reflect the
change immediately.
I'll see if I can put an eg up on the wiki tomorrow.
Stuart Boydell
-Original Message-
Are you saying
]
[mailto:[EMAIL PROTECTED] On Behalf Of Israel, John R.
Sent: 13 October 2008 13:01
To: 'u2-users@listserver.u2ug.org'
Subject: RE: [U2] Universe Triggers
There is still a hole to the wrapper approach.
Assuming you are trying to catch folks that use the ED (or AE) command, we
have to assume
-
From: Bill Haskett [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Saturday, October 11, 2008 2:50 AM
Subject: RE: [U2] Universe Triggers
Stuart:
Are you saying one should create a single trigger program like...
MASTER.TRIGGER.U
001 SUBROUTINE MASTER.TRIGGER.U (ExecStat, DictFlag
-
From: Bill Haskett [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Saturday, October 11, 2008 2:50 AM
Subject: RE: [U2] Universe Triggers
Stuart:
Are you saying one should create a single trigger program like...
MASTER.TRIGGER.U
001 SUBROUTINE MASTER.TRIGGER.U (ExecStat
Always ensure that any file opens in triggers resolve to specific paths
or accounts - that quick and dirty q-pointer from the 'wrong' account
will get you if you don't.
You can't debug through triggers (because they run in a transaction).
We also use a 'sub' trigger system but call @subroutines
PROTECTED] On Behalf Of Boydell, Stuart
Sent: Thursday, October 09, 2008 11:56 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Universe Triggers
Always ensure that any file opens in triggers resolve to specific paths
or accounts - that quick and dirty q-pointer from the 'wrong' account
: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett
Sent: 10 October 2008 14:50
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Universe Triggers
Stuart:
Are you saying one should create a single trigger program like...
MASTER.TRIGGER.U
001 SUBROUTINE
Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach
Sent: Friday, October 10, 2008 7:31 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Universe Triggers
Hi Bill
That's pretty much what I do, except each file has a list of small
subtriggers. That way, if we need
: RE: [U2] Universe Triggers
One gotcha is that once a trigger is on there, you can't easily
change/extend it unless your system has a downtime period in which everyone
is logged out. For this reason on 24x7 sites I use a master trigger that can
call subtriggers, held as a list in a parameter file
Poorly written, implemented, designed and tested triggers - will have a
high impact on your UV system.
Hopefully, you have down a full-scale (real world-like) production-like
test in your UAT environment prior to implementing them. If you have
done this and tested real world scenarios like file,
Why not just test it?
Create a file with some number of records. Write a simple program to
select the file and change one character in the record. Write it back
to the file. Time it.
Add an AFTER UPDATE trigger calling a subroutine that does *nothing*
but a RETURN. Run the program again.
, October 08, 2008 4:54 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Universe Triggers
One gotcha is that once a trigger is on there, you can't easily
change/extend it unless your system has a downtime period in which everyone
is logged out. For this reason on 24x7 sites I use a master trigger
Brian, definitely one of my concerns was dealing with changes that were
needed in the future so I like the idea of the subtriggers. In my little
bit of testing I found that you don't want to be messing with these very
often after you set them.
Jeff, are you suggesting that I can use an index
One gotcha is that once a trigger is on there, you can't easily
change/extend it unless your system has a downtime period in which everyone
is logged out. For this reason on 24x7 sites I use a master trigger that can
call subtriggers, held as a list in a parameter file. This means that a new
Brian wrote an excellent article about UniVerse Triggers in the Nov/
Dec 2007 of International Spectrum magazine (p. 12). You can download
that issue from
http://www.intl-spectrum.com/mag/NOVDEC.2007/default.aspx
Regards,
Clif
--
W. Clifton Oliver, CCP
CLIFTON OLIVER ASSOCIATES
Tel: +1
that use multiple triggers on
undersized files.
HTH,
Bill
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Hona, David S
Sent: Tuesday, October 07, 2008 10:55 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Universe Triggers
Poorly written
To ask a naive question: Having not used Universe, are triggers and their
impact substantially different between Unidata and Universe?
I've got 47+ triggers on various Unidata (7.1.x) files, some with 50+
records and not experienced any performance issues. Like others have
commented,
Mike:
Another thing to watch out for is the transaction constraints Brian
mentioned. Where I've seen this most often is if your application has
programs that add new records to a file without first getting a record
lock with a READU. UniVerse lets you write in the dark if you want
to.
From our testing a couple of years back (using version 10.2), we found
triggers to be very very very slow compared to indexes.
Regards,
Jeff Marcos
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Mike Roosa
Sent: Wednesday, 8 October 2008 2:22 PM
To:
-
From: Mike Randall[EMAIL PROTECTED]
Sent: 08/05/08 03:58:08
To: u2-users@listserver.u2ug.orgu2-users@listserver.u2ug.org
Subject: RE: [U2] UniVerse Triggers
Interesting, I actually saw the trigger reference under SQL
and made the
incorrect assumption
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach
Sent: Thursday, May 08, 2008 8:35 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UniVerse Triggers
Mike
If you check the recent issues (pdfs on their site) I wrote an article on
triggers
On UV triggers, I've used them often on UD and now have a great application
for them on UV. I searched the VOC and found no commands with the word
'trigger' in them. I was expecting the CREATE.TRIGGER of Unidata.What's
the syntax for setting them up in UV?
Mike Randall, MCP
[EMAIL PROTECTED]
630.235.2975
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Mike Randall
Sent: Wednesday, May 07, 2008 4:28 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UniVerse Triggers
On UV triggers, I've used them often on UD and now have
It's a UniVerse SQL command (yes, even if the file is not an SQL table).
CREATE TRIGGER triggername { BEFORE | AFTER } event [ OR event ] ON
tablename FOR EACH ROW CALLING ' program ' ;
Details are in chapter 5 of the UniVerse SQL Reference.
[AD]
Also, I will be conducting a webinar
PROTECTED] On Behalf Of Clifton Oliver
Sent: Wednesday, May 07, 2008 8:58 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] UniVerse Triggers
It's a UniVerse SQL command (yes, even if the file is not an SQL table).
CREATE TRIGGER triggername { BEFORE | AFTER } event [ OR event
I have several clients who have been using triggers for a couple of
years with no reported issues, other than the performance hit.
Regards,
Clif
--
W. Clifton Oliver, CCP
CLIFTON OLIVER ASSOCIATES
Tel: +1 619 460 5678Web: www.oliver.com
On Apr 25, 2008, at 11:42 PM, Horacio
We started using triggers some months ago and so far no problems at all...
I'm interested in what kind of instability issues you came across. Please
let me know.
( We are a 370-Micro$oft Windows shop!)
Horacio Pellegrino
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL
91 matches
Mail list logo
