Kbase P50664: Does a ROWID or RECID change during dump and load ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
26/08/2010 |
|
Status: Verified
GOAL:
Does a ROWID or RECID change during dump and load ?
GOAL:
Does a ROWID or RECID change during record delete and recreate ?
GOAL:
Why do records get a different ROWID after a dump and load ?
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
FIX:
Yes, the ROWID / RECID of a record will change during a dump and load.
During the dump operation, only the data contained in the records is dumped. Other information such as the exact location in the database or any index keys are ignored at this time.
During the load operation, the records will be re-created from scratch.
These newly created records will have a new ROWID / RECID assigned to them. It is unlikely that this ROWID / RECID is the same as that of the record which originally held the data.
For database tables and temp-tables even if all the records are deleted and recreated in the same order there is no guarantee that the ROWID / RECID will remain the same.
Also keep in mind that when a record is deleted, another newly created record can re-use the ROWID / RECID.
For these reasons, ROWID's and RECID's should be considered as temporary data from a development point of view, and should not be stored in a file or database table for future reference - they are not reliable enough for that.