Kbase P22887: Does the Data Dictionary format definition influence how record are stored in the Database?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/31/2009 |
|
Status: Unverified
GOAL:
Does the Data Dictionary format definition influence how record are stored in the Database?
GOAL:
Can I store in the Database a character field longer than the one I defined in the Data Dictionary?
GOAL:
Can I assign a character string that is longer than the field length I defined in the DEFINE VARIABLE statement
FACT(s) (Environment):
All Supported Operating Systems
Progress 7.x
Progress 8.x
Progress 9.x
OpenEdge 10.x
FIX:
Progress stores data in variable-length fields.
This means that you can store in the Database a character field longer than the one you have defined in the Data Dictionary
This can be done using the FORMAT option with the UPDATE and SET statements or using directly and ASSIGN statement.
Also by storing data shorter than the predefined format you'll use only the byte requested for the actual data length of the record.
The only limitation is the Data Dictionary "load program" that only loads character fields that are no longer than the format you defined in the Dictionary.