Another resource is Brian Leach's article on UniVerse triggers on
page 12 of the Nov/Dec 2007 issue of International Spectrum magazine.
The issue can be downloaded from:
http://www.intl-spectrum.com/mag/NOVDEC.2007/default.aspx
Regards,
Clif
On Aug 28, 2008, at 5:24 PM, Anthony Caufield wrote:
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: u2-users@listserver.u2ug.org
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: u2-users@listserver.u2ug.org
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
u2-users@listserver.u2ug.org
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
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/
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
