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
