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
Has anyone setup and used Unix/Universe triggers. Where do you start? Any
manuals to get started?
Regards,
Dan Jorgenson
Senior Systems Analyst
SICK, Inc.
6900 West 110th Street
Minneapolis, MN 55438 USA
Phone: 952.941.6780
Fax: 952.941.9287
Direct: 952.829.4732
http://www.sickusa.com
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
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 non-helpful) section on triggers
in the Universe System Description documentation but I'm still a bit
confused. I have a program (subroutine) written with the
: 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@listserver.u2ug.org
Subject: [U2] Universe Triggers
AIX 5.3 UV 10.2Universe
I want to put a trigger on a file to send an email message
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
, 2010 11:47 AM
To: U2-Users@listserver.u2ug.org
Subject: [U2] Universe Triggers
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 non-helpful) section on triggers
in the Universe System Description documentation
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
Im testing using triggers to maintain an Audit log of transactions.
Everything works, the file, the subroutine, but the trigger process is
extremely slow.
My test program loops through 1 to 1 and writes a record to my test file
with the trigger. Without the trigger in place the program
...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] On Behalf Of Curt Stewart
Sent: Friday, October 30, 2009 10:47 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Universe Triggers
I'm testing using triggers to maintain an Audit log of transactions.
Everything works, the file
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
the program :-)
You must set the trigger on event UPDATE and time BEFORE.
My two pence.
Manu
-Message d'origine-
De : [EMAIL PROTECTED] [mailto:owner-u2-
[EMAIL PROTECTED] De la part de Susan Joslyn
Envoyi : lundi 1 dicembre 2008 17:16
@ : u2-users@listserver.u2ug.org
Objet : [U2] Universe
-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
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 suggest
that I could use SetDiagnostic to fail this . but I'm
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
la part de Susan Joslyn
Envoyi : mardi 25 novembre 2008 18:10
@ : u2-users@listserver.u2ug.org
Objet : [U2] Universe triggers + SB+
Has anyone successfully enabled Universe trigger programs that call SB+
enabled programs? I'm getting COMMON mis-match and other errors.
TIA,
Susan
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
Has anyone successfully enabled Universe trigger programs that call SB+
enabled programs? I'm getting COMMON mis-match and other errors.
TIA,
Susan Joslyn
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
@listserver.u2ug.org
Objet : [U2] Universe triggers + SB+
Has anyone successfully enabled Universe trigger programs that call SB+
enabled programs? I'm getting COMMON mis-match and other errors.
TIA,
Susan Joslyn
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please
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
] Universe Triggers
Hi Kate,
As another suggestion (if only tracking changes by 'ED') why not wrap
the 'ED' function and catalog it under a new name?
Eg: catalog the below code as 'ED' and re-catalog 'ED' as some ambiguous
name.
[snipped
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
: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Mike Roosa
Sent: Wednesday, 8 October 2008 2:22 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Universe Triggers
We are getting ready to implement triggers on a universe system running
under Windows Server 2003. I created a trigger
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
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Mike Roosa
Sent: 08 October 2008 04:22
To: u2-users@listserver.u2ug.org
Subject: [U2] Universe Triggers
We are getting ready to implement triggers on a universe
system running under
-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Mike Roosa
Sent: 08 October 2008 04:22
To: u2-users@listserver.u2ug.org
Subject: [U2] Universe Triggers
We are getting ready to implement triggers on a universe
system running under Windows Server 2003. I created
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.
To: u2-users@listserver.u2ug.org
Subject: [U2] Universe Triggers
We are getting ready to implement triggers on a universe system running
under Windows Server 2003. I created a trigger and tested it out and it
appears to do exactly what we need. My question is are there any
gotchas or
issues we
-
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
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Baker Hughes
Sent: Friday, April 25, 2008 11:02 AM
To: 'u2-users@listserver.u2ug.org'
Subject: [U2] UniVerse Triggers
Hello,
We have received reports that UV triggers have shown some instability. Does
anyone
[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
Excuse me. I mistyped. That is three 90 minute sessions, not one hour.
Regards,
Clif
Begin forwarded message:
From: Clifton Oliver [EMAIL PROTECTED]
Date: May 7, 2008 5:58:05 PM PDT
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] UniVerse Triggers
It's a UniVerse SQL command (yes
'
Subject: [U2] UniVerse Triggers
Hello,
We have received reports that UV triggers have shown some
instability. Does
anyone have anything to share on this?
We have been using them for a couple of years with no issues but
were hoping
for more details from other users, if available.
Thanks much
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
:[EMAIL PROTECTED] On Behalf Of Baker Hughes
Sent: Friday, April 25, 2008 8:02 AM
To: 'u2-users@listserver.u2ug.org'
Subject: [U2] UniVerse Triggers
Hello,
We have received reports that UV triggers have shown some
instability. Does
anyone have anything to share on this?
We have been using them
Hello,
We have received reports that UV triggers have shown some instability. Does
anyone have anything to share on this?
We have been using them for a couple of years with no issues but were hoping
for more details from other users, if available.
Thanks much,
-Baker
---
u2-users mailing
PROTECTED] On Behalf Of Baker Hughes
Sent: Friday, April 25, 2008 8:02 AM
To: 'u2-users@listserver.u2ug.org'
Subject: [U2] UniVerse Triggers
Hello,
We have received reports that UV triggers have shown some instability. Does
anyone have anything to share on this?
We have been using them for a couple
98 matches
Mail list logo