OK. One problem down, the filename contained an "&" which seemed to be giving problems. I setup a Q pointed from N&ABTP to NABTP.
now I get: CREATE TRIGGER TRIG1 AFTER INSERT OR UPDATE OR DELETE ON NABTP FOR EACH ROW CALLILNG "*TRIGGER_TEST"; UniVerse/SQL: Invalid file type specified. Warning: SICA information could not be read properly!! George > > > -----Original Message----- > > From: [email protected] [mailto:u2-users- > > [email protected]] On Behalf Of Brian Leach > > Sent: Friday, July 10, 2009 4:26 PM > > To: 'U2 Users List' > > Subject: Re: [U2] UV and triggers > > > > > > 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 > > > _______________________________________________ > 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
