Tom, The following was provided recently by Geoffrey Mitchell:
Date: Thu, 07 Apr 2005 17:34:50 -0500 From: Geoffrey Mitchell <[EMAIL PROTECTED]> Subject: Re: [U2] UV Triggers The correct syntax should be: CREATE TRIGGER trigger_name [BEFORE | AFTER] UPDATE ON file_name FOR EACH ROW CALLING 'subroutine'; Note the semi-colon. All SQL commands end with one. Failure to include it will result in the "SQL+" prompt that you got. The file does not have to be an SQL table, but it cannot be a type 1 or type 19 file (it must have a header to put SICA information in). Also, your trigger subroutine must be globally cataloged. See thread here: http://www.indexinfocus.com/dl/u2list/200207/35152.html Check the archives for other posts. hth Dave Dave Taylor President Sysmark Information Systems, Inc. 49 Aspen Way Rolling Hills Estates, CA 90274 800-SYSMARK (800-797-6275) (O) 310-544-1974 (P) 800-339-1497 (F) 310-377-3550 Your Source for Integrated EDI Translation and DataSync Integration www.sysmarkinfo.com ----- Original Message ----- From: "Tom Dodds" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Monday, August 01, 2005 9:12 AM Subject: RE: [U2] Trigger creation > Sorry UV 10..1.7 on AIX 5.2.2 > > > Tom Dodds > [EMAIL PROTECTED] > 630-235-2975 > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King > Sent: Monday, August 01, 2005 10:41 AM > To: [email protected] > Subject: RE: [U2] Trigger creation > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Tom Dodds > > 1. Can you create triggers on non-SQL tables > 2. If the answer to #1 is Yes, how do you create triggers on > non-SQL > tables. > > ---------------- > > What platform and version? > > -Kevin > [EMAIL PROTECTED] > http://www.PrecisOnline.com > ------- > 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/
