Bear in mind though that a trigger is a very intensive thing to add to a file. Just try timings on writes with and without them. Also you cannot replicate a file with triggers (major problem for use that I would LOVE IBM to fix.....)
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michael J Burbo Sent: 31 August 2004 03:59 To: [EMAIL PROTECTED] Subject: [U2] Dot Commands Mike, Another way to correct the "" or NULL saved item is to setup a Write Trigger and if the ID is NULL no write or replace with the person's logon and date/time this will also help you find who is causing your NULL items. A Trigger program can be set up an most any file and very good this to ensure history of changes are keep. If a change is made the Trigger program can write a copy of the original record into a <file.HIST> - Time and Date stamp it (User info too). You May also reformat some data items too. Michael Burbo [EMAIL PROTECTED] Media, PA 19063 610 358 9888 ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
