Can I have tables from multiple UV accounts in the same SQL Schema? Or will Have to Maintain multiple Schemas and use the schema.table notation when referring to it?
-----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