Brian, An excellent article. One that should be required reading by every systems architect that works in the U2 environment. I'm stunned that many don't realize the power in triggers, especially those of you supporting systems with no source!
Again, great article. Mike Randall, MCP -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach Sent: Thursday, May 08, 2008 8:35 AM To: [email protected] Subject: RE: [U2] UniVerse Triggers Mike If you check the recent issues (pdfs on their site) I wrote an article on triggers for Spectrum you might find useful. Brian -----Original Message----- From: "Mike Randall"<[EMAIL PROTECTED]> Sent: 08/05/08 03:58:08 To: "[email protected]"<[email protected]> Subject: RE: [U2] UniVerse Triggers Interesting, I actually saw the trigger reference under SQL and made the incorrect assumption that it was referring to actual SQL commands rather than calling BASIC subroutines. Thanks for correction. Mike Randall, MCP -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Clifton Oliver Sent: Wednesday, May 07, 2008 8:58 PM To: [email protected] Subject: Re: [U2] UniVerse Triggers It's a UniVerse SQL command (yes, even if the file is not an SQL table). CREATE TRIGGER triggername { BEFORE | AFTER } event [ OR event ] ON tablename FOR EACH ROW CALLING ' program ' ; Details are in chapter 5 of the UniVerse SQL Reference. [Message truncated. Tap Edit->Mark for Download to get remaining portion.] ------- 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/
