Kbase P7994: How Progress works with schema changes in version 8 and befo
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/22/2003 |
|
Status: Unverified
GOAL:
How Progress works with schema changes in version 8 and before
FIX:
In v8 and before we do not have anything like Fast Schema Change or Schema Versioning, those are new features in version 9.
Therefore, adding/deleting a field will cause Progress to go through each and every record and update the physical layout accordingly (adding the initial value or deleting the field). It will take time depending on the number of records involved.
Changing data type (int to decimal or vice versa) is actually 3 operations:
- Add the new field. Commit the Data Dictionary changes (and Progress
updates all records).
- Move the data from the old field to the new one (must be done with a 4GL program).
- Remove the old field. Commit the Data Dictionary changes (and Progress
updates once again all records).
Only changing the format will be done in no time.