Robert Porter wrote:
Just a quick note on indexes... and kind of goes to the EMC question.
The location of the index is stored in header of the file itself! This can lead to a problem if you have a copy of the data somewhere else
and try to use it. For example, we'll occasionally want to see how a
file/record looked from a few days ago. We'll restore it to
an alternate path. The first thing you MUST DO before you touch that file is SET.INDEX (filename) TO NULL -- If you don't and you
start accessing it (iirc, even a read can make it go check the indexes) it will start updating the live file's index with the restored files
data. Best part if you may not even know, until things (like SELECTs just
don't work in your production account.
Robert
Robert F. Porter, MCSE, CCNA, ZCE
Sr. Programmer / Analyst
Laboratory Information Services
Ochsner Health System
(504) 842 - 5185
This transmission (including any attachments) may contain confidential information, privileged material (including material protected by the solicitor-client or other applicable privileges), or constitute non-public information. Any use of this information by anyone other than the intended recipient is prohibited. If you have received this transmission in error, please immediately reply to the sender and delete this information from your system. Use, dissemination, distribution, or reproduction of this transmission by unintended recipients is not authorized and may be unlawful.
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
Note that this is for Universe only, correct Robert? In Unidata, the
index is in the present working dir as X_{filename}
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users