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 ar
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
I always drop all the triggers on a file, so the syntax I use is this:
DROP TRIGGER (file name) ALL ;
I forgot in my previous email that you have to end your command with a
semi-colon.
CREATE TRIGGER BEFORE_INSERT BEFORE INSERT ON (FILE NAME) FOR EACH ROW
CALLING "*(subroutine name)" ;
And what
While the trigger needs to be globally cataloged, it can call a locally
cataloged routine. Every trigger we have simply calls a 2nd locally cataloged
program that does all the work. Without this, it makes testing very difficult
between a system that has live/test accounts on the same box.
Joh
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 o
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 goo
Lock the record before you write it.
Henry Unger
Sent from my iPad
On Jul 30, 2010, at 2:47 PM, "Jeff Schasny" 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
> account) which
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" ill
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 att
We have a similar process - we have the Trigger write a record to an
"audit" file. Then there's a separate Phantom running that's polling the
audit file and doing what-ever.
Mark
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org]
Have the subroutine that's called from your trigger routine write a
record into a file with the details for emailing.
Then create a program that runs in cron that reads that file and sends
your emails
Barry Rutherford
Programmer / Analyst
MobilexUSA
930 Ridgebrook Rd, 3rd Floor
Sparks, MD 21152
L
Yeah, thats what I've been thinking.
Thanks all.
Barry Rutherford wrote:
Have the subroutine that's called from your trigger routine write a
record into a file with the details for emailing.
Then create a program that runs in cron that reads that file and sends
your emails
Barry Rutherford
Pr
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" wrote:
> Thank you all.
>
> After much putzing with the various parts involved it is beginning to look
> like my original pla
In summary, to get triggers working as you want in UV you need to:
a) Have a stub subroutine which is globally catalogued
b) This stub subroutine is the one which you attach to the trigger
c) This stub subroutine calls the main subroutine which does all the
work
The benefit of this is the stub su
Nick, Dawn, Tony, David, Glen, John, Jeff, Bill, everyone.
Thanks for the posts on this thread. There is good material for me to share
with the rest of our team and hopefully overcome inertia and set some new
direction.
Thank you.
-Baker
-Original Message-
From: u2-users-boun...@lists
dont forget that if the file is distributed that it requires a trigger on each
file part.
From: u2-users-boun...@listserver.u2ug.org
[u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny
[jscha...@gmail.com]
Sent: Friday, July 30, 2010 10:12 AM
To: U
1. When I buy electronic components, the first place I look is Mouser. I find
it a kick that Mouser is running U2.
2. If it can be revealed... the servers there that run U2... are they all
Windows Servers?... Are some, any, or all *nix machines?
--Bill
-Original Message-
From: u2-users
18 matches
Mail list logo
