The file doesn't have to be part of a schema and doesn't have to be a SQL table: Universe will add a SICA to the file as part of the trigger definition. But it does need to be a file and not a directory i.e. not type 1 or 19.
Also the trigger routine should be globally cataloged. Brian > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of > George Gallen > Sent: 10 July 2009 21:02 > To: U2 Users List > Subject: Re: [U2] UV and triggers > > I think the problem is I don't have a schema defined to store > the trigger in. > > I've never worked with SQL related extensions. > > Is this a lot of work to setup the schema? Will if affect the > file I'm setting the trigger on in any way? > > Thanks > George > > > -----Original Message----- > > From: [email protected] [mailto:u2-users- > > [email protected]] On Behalf Of Joshua Gallant > > Sent: Friday, July 10, 2009 3:58 PM > > To: U2 Users List > > Subject: Re: [U2] UV and triggers > > > > It seems okay to me. What file type is the file you're > trying to add > > the trigger to? > > > > - Josh > > > > > > -----Original Message----- > > From: [email protected] > > [mailto:[email protected]] On Behalf Of George > > Gallen > > Sent: Friday, July 10, 2009 3:20 PM > > To: U2 Users List > > Subject: [U2] UV and triggers > > > > I need to setup a trigger on a Universe file to track > changes to one > > item. > > > > The book is quite confusing on setting up triggers... > > I understand how to compile the program (and read in the > appropriate > > data). > > > > I just can't figure out how to get the trigger on the file to work > > > > I tried > > > > CREATE TRIGGER EMAILUPDT AFTER INSERT OR UPDATE OR DELETE ON N&ABTP > > FOR EACH ROW CALLING 'BTPEMAILTRIGGER' ; (also tried unquoted) > > > > which responds with statement triggers are not supported. > > > > I'm on Universe 10.0.2 INFORMATION FLAVOR. > > RELLEVEL > > 001 X > > 002 10.0.2 > > 003 INFORMATION > > 004 INFORMATION.FORMAT > > 005 10.0.2 > > > > > > George Gallen > > Senior Programmer/Analyst > > Accounting/Data Division, EDI Administrator [email protected] > > ph:856.848.9005 Ext 220 > > The Wyanoke Group > > http://www.wyanokegroup.com > > > > > > > > _______________________________________________ > > U2-Users mailing list > > [email protected] > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > _______________________________________________ > > U2-Users mailing list > > [email protected] > > http://listserver.u2ug.org/mailman/listinfo/u2-users > _______________________________________________ > U2-Users mailing list > [email protected] > http://listserver.u2ug.org/mailman/listinfo/u2-users > _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
