Stuart, Bscan will not work against the main file, but works on the individual files.
Bernard Lubin Development Department Reynolds and Reynolds -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Boydell, Stuart Sent: Friday, 22 June 2007 2:06 PM To: [email protected] Subject: RE: [U2] [UV] Trigger(s) on distributed file Many thanks to the responants, I am just investigationg what is involved in converting a file to DF. So far: - Triggers are required on each part. You cannot create a trigger on the master and there is no similar functionality to the 'CREATE.INDEX' command on DFs. - BSCAN doesn't work - but SELECTINDEX does. - And a gotcha, if you artificially populate the parts contra to the DF algorithm (and possibly if you change it) You need to rebuild the indices. 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 [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
