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 u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
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: u2-users@listserver.u2ug.org 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 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/
RE: [U2] Trigger creation
I'll let the UV experts speak more to that, but I do believe UV10 was the first that allowed triggers on non-SQL tables. You might check the docs for syntax. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Dodds Sorry UV 10..1.7 on AIX 5.2.2 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Trigger creation
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: u2-users@listserver.u2ug.org 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: u2-users@listserver.u2ug.org 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 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Trigger creation
Tom Yes you can. For the complete syntax, type HELP SQL CREATE TRIGGER at TCL. This gives the argument list for the trigger subroutine. I seem to recall that if you are going to access the file from various accounts, the trigger subroutine needs to be globally cataloged. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Dodds Sent: 01 August 2005 17:12 To: u2-users@listserver.u2ug.org 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: u2-users@listserver.u2ug.org 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 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Trigger creation
Thanks for the reply Kevin 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 11:31 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Trigger creation I'll let the UV experts speak more to that, but I do believe UV10 was the first that allowed triggers on non-SQL tables. You might check the docs for syntax. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Dodds Sorry UV 10..1.7 on AIX 5.2.2 --- 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/