Re: [U2] Triggers in Universe

2013-01-29 Thread Bill Haskett
ng triggers and allowing individual dbms accounts to use local versions of trigger subroutines. Bill - Original Message - *From:* br...@brianleach.co.uk *To:* 'U2 Users List' *Date:* 1/29/2013 1:08 AM *Subject:* Re: [U2] Triggers in Universe Peter Yes, they are still cached bu

Re: [U2] Triggers in Universe

2013-01-29 Thread Wols Lists
On 28/01/13 23:26, Peter Cheney wrote: > Could use the trigger program to call one or more external subroutines based > on the trigger action required? > I understand that the external subroutines are not cached and can be updated > without needing to stop/start the master trigger. > Never tried

Re: [U2] Triggers in Universe

2013-01-29 Thread Brian Leach
: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney Sent: 28 January 2013 23:26 To: U2 Users List Subject: Re: [U2] Triggers in Universe Could use the trigger program to call one or more external subroutines based on the trigger action required? I

Re: [U2] Triggers in Universe

2013-01-28 Thread Peter Cheney
...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Saturday, 26 January 2013 20:19 To: U2 Users List Subject: Re: [U2] Triggers in Universe Remember also that triggers, as subroutines, are cached in memory so if you recompile a trigger the changes won'

Re: [U2] Triggers in Universe

2013-01-26 Thread Brian Leach
LOG. We do it all the time for our file-based triggers. >> >> Perry >> >> -Original Message- >> From: u2-users-boun...@listserver.u2ug.org [mailto: >> u2-users-boun...@listserver.u2ug.org] On Behalf Of Bobby Worley >> Sent: Friday, January 25

Re: [U2] Triggers in Universe

2013-01-25 Thread Bobby Worley
l the time for our file-based triggers. > > Perry > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org [mailto: > u2-users-boun...@listserver.u2ug.org] On Behalf Of Bobby Worley > Sent: Friday, January 25, 2013 3:03 PM > To: U2 Users List > Subje

Re: [U2] Triggers in Universe

2013-01-25 Thread Perry Taylor
...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bobby Worley Sent: Friday, January 25, 2013 3:03 PM To: U2 Users List Subject: Re: [U2] Triggers in Universe The problem was the locally cataloged program.I was in an account that is PICK flavor and wouldn't allow g

Re: [U2] Triggers in Universe

2013-01-25 Thread Bobby Worley
Bobby Worley > Sent: Friday, January 25, 2013 1:33 PM > To: U2 Users List > Subject: [U2] Triggers in Universe > > I'm up against a wall here - trying to use triggers for the first time, on > Universe. Can't seem to get my test to work - > > Universe on AIX: >

Re: [U2] Triggers in Universe

2013-01-25 Thread Woodward, Bob
Sent: Friday, January 25, 2013 1:33 PM To: U2 Users List Subject: [U2] Triggers in Universe I'm up against a wall here - trying to use triggers for the first time, on Universe. Can't seem to get my test to work - Universe on AIX: RELLEVEL 001 X 002 11.1.9 003 PICK 004 PICK.FORMAT 005

Re: [U2] Triggers in Universe

2013-01-25 Thread Allen Egerton
Has to be globally cataloged. And there's a prescribed list of args. There are some 'best practices' i can pass on to you when im at a fullsize keyboard if you'd like. (Allen - Sent from my paperweight) On Jan 25, 2013, at 4:33 PM, Bobby Worley wrote: > I'm up against a wall here - trying to

[U2] Triggers in Universe

2013-01-25 Thread Bobby Worley
I'm up against a wall here - trying to use triggers for the first time, on Universe. Can't seem to get my test to work - Universe on AIX: RELLEVEL 001 X 002 11.1.9 003 PICK 004 PICK.FORMAT 005 11.1.9 >BASIC BDW TRIGTEST Compiling: Source = 'BDW/TRIGTEST', Object = 'BDW.O/TRIGTEST' * Compi