Off the top of my head - AND CHECK TO MAKE SURE... You can't create triggers (or indexes, or anything like that) on the master, because it only exists as a record in &PARTFILES&).
But - and I'm pretty sure this is true of indices at least - if you try and create an index on the master, it will loop through the list of partfiles and create an index on each individual partfile. The same is likely to be true of triggers. Where this WILL bite you, is when you create a new partfile. By default, it won't have any indices, or triggers, or whatever. You'll need to add them to that partfile. So - the situation with indices (and probably triggers etc) is that creating them on the master is a legit thing to do. But under the covers it is actually doing it to each individual partfile. So when you add a new partfile, they won't get automatically added to the new partfile. Cheers, Wol -----Original Message----- From: Boydell, Stuart [mailto:[EMAIL PROTECTED] Sent: 21 June 2007 04:29 To: u2-users@listserver.u2ug.org Subject: [U2] [UV] Trigger(s) on distributed file Just to check as I couldn't find doco on it - Do I create triggers on each part of a DF? Or is there a way to have the trigger on the master? Cheers, Stuart ********************************************************************** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this communication in error, please reply to this e-mail to notify the sender of its incorrect delivery and then delete it and your reply. It is your responsibility to check this email and any attachments for viruses and defects before opening or sending them on. Spotless collects information about you to provide and market our services. For information about use, disclosure and access, see our privacy policy at http://www.spotless.com.au Please consider our environment before printing this email. ********************************************************************** ------- 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/
