Kbase P105084: How to change the number of extents for a field
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Unverified
GOAL:
How to change the number of extents for a field
GOAL:
How to add or remove an extent for a field
FIX:
Under the Data Dictionary, the Extent value for a field displayed under its Field Properties indicates whether the field is an array field. The Extent fill-in displays the extent value. The extent value is fixed at creation time of the field, but if the value needs to be added, the following steps can be used -
1. Ensure the database is stopped and then back it up.
2. Under the Data Dictionary add a new field into the relevant table, specifying the required number of extents. This new field can be created using the Copy Field function, but ensure to select Modify First so that the number of extents can be specified.
3. Use a 4GL procedure to dump the data from the old field.
4. Use a 4GL procedure to load the data into the new field.
5. Delete the old field. Although it might be unlikely that a field containing an array might be used in an index, if the field is used in any indexes, those indexes must first of all be deleted.
6. Rename the new field to what the old field was called.
7. Re-add any indexes that had to be deleted, and then carry out an idxbuild on those indexes.
8. Backup again as required.
If extents are removed, ensure to load only those extents required.
Tested with 91E01 on w2000.