I also found that the tablename has to be a type "F" in the VOC, and not a Q pointer At least when setting up the trigger.
I'm guessing that if I replaced the Q pointer, with an F and the DICT/FILE names with Absolute file names /directory/tree/D_xxxx and /directory/tree/xxxx I most likely Could set the trigger from whatever account that new F pointer were defined in, even If the file were in another account But it's easier to keep the Q pointer, and define the trigger from the account where The file actually lives! George -----Original Message----- From: u2-users-boun...@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 information in there. Brian -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: 24 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 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 _______________________________________________ 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
