Thanks so much, but here's what I'm getting as a response: Universe/SQL: You must create a schema before you may create SQL tables.
-Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Martin Canty Sent: Thursday, April 07, 2005 3:57 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UV Triggers Hi Kevin, Here are some sample commands; part of the trick is in the way you catalog the trigger subroutine >BASIC BP TRIG001 >ICATALOG BP *TRIG001 FORCE >CREATE TRIGGER TRG1 SQL+ AFTER INSERT ON PARTS FOR EACH ROW CALLING "*TRIG001"; Martin -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King Sent: Thursday, April 07, 2005 2:38 PM To: u2-users@listserver.u2ug.org Subject: [U2] UV Triggers I am making my first foray into Universe triggers having knowledge only of how it works with Unidata and the Universe documentation, and am having a devil of a time. Is it a requirement that in Universe, the file must be created via SQL in order to put triggers on it? And then what of this CREATE TRIGGER syntax? The documentation says: CREATE TRIGGER trigger_name [BEFORE | AFTER] UPDATE ...but it doesn't nominate the file where the trigger is to be deployed. I found an example elsewhere that has a bit more syntax: CREATE.TRIGGER trigger_name [BEFORE | AFTER] UPDATE ON file_name FOR EACH ROW But entering that leaves me at a SQL+ prompt and when I <cr> it gives me a message that says "You must create a schema before you may create SQL tables.". My trigger subroutine is compiled and catalogued according to the documentation, and I'd really like to test it, but ... these issues keep getting in the way. Anybody care to launch a rescue? -Kevin HYPERLINK "mailto:[EMAIL PROTECTED]"[EMAIL PROTECTED] http://www.PrecisOnline.com -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.9.4 - Release Date: 4/6/2005 ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.9.4 - Release Date: 4/6/2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.9.4 - Release Date: 4/6/2005 ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
