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: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > > boun...@listserver.u2ug.org] 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 > 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
