Kbase P66630: How to take advantage of Fast Schema Change and add new fields with a known initial value in Progres
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/12/2009 |
|
Status: Verified
GOAL:
How to take advantage of Fast Schema Change and add new fields with a known initial value in Progress version 8.
FACT(s) (Environment):
Progress 8.x
All Supported Operating Systems
OpenEdge Category: Database
FIX:
Fast Schema Change was introduced in Progress version 8.2A.
One of the requirements to use the Fast Schema Change in version 8 was that a new fields initial value needed to be set to the unknown value, ?.
In order to add a field with an initial value other than ? and still take advantage of the Fast Schema Change, do the following:
1. Enter Progress Data Dictionary.
2. Add new field(s).
3. The initial value of the new field must be set to the unknown value ?
4. Exit Progress Data Dictionary.
5. Re-enter DD and make the second change to desired value, i.e. sss.
6. Run the following procedure to update every row so that it has the required initial value.
FOR EACH table-with-new-fields:
ASSIGN new-field = required-initial-value, i.e. "sss".
END.