It will not get updated automatically. That would be magic. For that to happen the index must be based entirely on the contents of the record and/or record id.
Things like that I would tend to build the index on the key to the TRANS'd data, and maybe have another index on the field in the secondary file. An invoice file with a field that shows the customer name for example. You could index the customer name in the customer file, the customer key in the invoice file. Find the list of customer keys for a customer name, and use that to get a list of invoice records using the customer keys. But if you've got, for example, an index based on the words in the record, and you have a list of words you want to ignore (not build an index for) stored in another file - that would be a case where the "source doesn't change very often" and you would want to bring the system down to rebuild the index. -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Tuesday, November 09, 2010 3:47 PM To: U2 Users List Subject: [U2] Index based on an I desc of TRANS data I just created an Index on a fairly large file based on an I Desc. The IDESC is combination of Concatenating 5 TRANS()'d fields. After the index was built, it works great....but just curious, Will the index get updated automatically, when the source file's data changes? (remember, the index is based on TRANS'd data), Or will I need to periodically rebuild the index, which in itself wouldn't be an issue as the source file doesn't change very often. This is on UV. George George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.com _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users <html> <body> ________________________________ Dave Davis Team Lead, R&D P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif] 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. </body> </html> _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users