George The basic syntax looks correct (other than the typo) except:
- The name of the trigger subroutine must be in single quotes (being SQL). - Instead of a Q pointer, what happens if you just copy the file pointer across to the new name? - Finally, you must be an adminstrator to run this There should be no problem adding the trigger to a type 30 file. The only other thing that I can think of, is whether the file revision is too old? I don't know if there is any back limit on that. Regards Brian > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of > George Gallen > Sent: 10 July 2009 21:55 > To: U2 Users List > Subject: Re: [U2] UV and triggers > > 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 > _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
