Thanks to everyone for their replies. If I had actually kept track of all the quote escaping I had tried I would have seen I missed the most obvious as it is working fine now. Guess I needed one more Diet Dr Pepper. :-)
Jay -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach Sent: Tuesday, November 02, 2004 7:50 AM To: [EMAIL PROTECTED] Subject: RE: [U2] Question about Triggers Jay, The following works for me: CREATE TRIGGER STUPID_TRIGGER BEFORE INSERT OR UPDATE OR DELETE ON "STUPID-FILE" FOR EACH ROW CALLING '*STUPID.TRIGGER'; Adding trigger "STUPID_TRIGGER" >ED STUPID-FILE TEMP New record. ----: i 0001= HELLO 0002= Bottom at line 1. ----: fi Message from trigger STUPID_TRIGGER: Received trigger STUPID_TRIGGER for Event INSERT "TEMP" filed in file "STUPID-FILE". Brian Jay Falck wrote: > I have a need to put a trigger on a couple of Universe files that have names > that are causing a problem. I'd like to know if there is a good work around. > > The first file is a reserved work in SQL (AUTHORIZATION) and the other > contains a dash (STATE-FILE). > > I thought of naming the files something different and putting a Q-PTR to the > old name in the affected accounts but this is a major system from a Vendor > that isn't too keen on changes such as that. > > I can't create a Q-PTR with a different name and put the trigger on that as > triggers have to be on the actual file. > > I have tried various combinations of quote and double quote escaping but no > luck. > > Any help would be greatly appreciated. > > Thanks, > > Jay > ------- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
