Clif, You are very correct I use a few of them on several files for auditing of my universe files. It was tough for me as well to find but then I found it they are the same commands whether its SQL tables or universe files. Make sure nobody has the file open when you create them thou.
Tony -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Clifton Oliver Sent: Thursday, August 28, 2008 4:07 PM To: [email protected] Subject: Re: [U2] Triggers Chapter 5 of the 10.2 SQL Reference manual is correct. The file does not have to be SQLized, but you still have to use valid SQL syntax for the TCL commands used to CREATE and DROP them, ie., ' for literals (not ") and you must end the command with a semi-colon (;). Regards, Clif -- W. Clifton Oliver, CCP CLIFTON OLIVER & ASSOCIATES Tel: +1 619 460 5678 Web: www.oliver.com The information in the System Description manual is inaccurate. On Aug 27, 2008, at 8:32 AM, Tom Dodds wrote: > Universe SQL Reference if I remember correctly. > > HTH > > Tom Dodds > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Alspach, > Vance > Sent: Wednesday, August 27, 2008 8:54 AM > To: [email protected] > Subject: [U2] Triggers > > What manual contains information on creating Universe triggers for > non-SQLized > files? I cannot seem to find it in any manual > > UV 10.2.4 Pick format > IBM RS6000 > > Vance Alspach > > > ________________________________ > CONFIDENTIALITY. This electronic mail and any files transmitted > with it may > contain information proprietary to Deere & Company, or one of its > subsidiaries > or affiliates, and are intended solely for the use of the > individual or > entity > to whom they are addressed, shall be maintained in confidence and not > disclosed to third parties without the written consent of the > sender. If you > are not the intended recipient or the person responsible for > delivering the > electronic mail to the intended recipient, be advised that you have > received > this electronic mail in error and that any use, dissemination, > forwarding, > printing, or copying of this electronic mail is strictly > prohibited. If you > have received this electronic mail in error, please immediately > notify the > sender by return mail. > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ > > __________ Information from ESET NOD32 Antivirus, version of virus > signature > database 3392 (20080827) __________ > > The message was checked by ESET NOD32 Antivirus. > > http://www.eset.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/
