First I dropped the schema I setup on that account Then I tried to add a trigger to that file....and 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 file? Interesting. George -----Original Message----- From: u2-users-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 Professionals, 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: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 TABLE table.... I have this account setup in UV_SCHEMA already (for another trigger), And the TABLE table is a Q pointer to another filename, which does not exist in THIS account. Do I need to setup the other account in UV_SCHEMA, and then create the trigger From that account on the file from within the account it resides? _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users