July 2012 20:31
To: U2 Users List
Subject: Re: [U2] UV Triggers / SQL
First I dropped the schema I setup on that account Then I tried to add a
trigger to that fileand it didn't give me any errors.
So...I can add triggers to UV files that reside in accounts that are not
defined in UV_SCHEMA
...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach
Sent: Wednesday, July 25, 2012 5:50 AM
To: 'U2 Users List'
Subject: Re: [U2] UV Triggers / SQL
George
Yes, you've been able to do that for some time. It simply adds a SICA block
to the file and logs the trigger
I'm trying to setup a trigger on a UV File.
I created the cataloged subroutine,
I'm running as user uvsql
I type in CREATE TRIGGER name AFTER INSERT ON table FOR EACH ROW CALLING
'*subroutine';
And it says it can't find TABLE table
I have this account setup in UV_SCHEMA already (for
: Tuesday, July 24, 2012 2:06 PM
To: U2 Users
Subject: [U2] UV Triggers / SQL
I'm trying to setup a trigger on a UV File.
I created the cataloged subroutine,
I'm running as user uvsql
I type in CREATE TRIGGER name AFTER INSERT ON table FOR EACH ROW CALLING
'*subroutine';
And it says it can't find
Of David L. Wasylenko
Sent: Tuesday, July 24, 2012 3:04 PM
To: U2 Users List
Subject: Re: [U2] UV Triggers / SQL
LOGTO the account - it'll work there.
... david ...
David L. Wasylenko
President, Pick Professionals, Inc
w) 314 558 1482
d...@pickpro.com
-Original Message-
From: u2-users
, Inc
w) 314 558 1482
d...@pickpro.com
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Tuesday, July 24, 2012 2:17 PM
To: U2 Users List
Subject: Re: [U2] UV Triggers / SQL
Can I have tables from
-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David L. Wasylenko
Sent: Tuesday, July 24, 2012 3:04 PM
To: U2 Users List
Subject: Re: [U2] UV Triggers / SQL
LOGTO the account - it'll work there.
... david ...
David L. Wasylenko
President, Pick
