Kbase P14189: Progress/400 CHGPRODCT converts logical fields to character in p__field file
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress/400 DataServer
SYMPTOM(s):
Progress/400 CHGPRODCT converts logical fields to character in p__field file
When performing CHGPRODCT after making changes to a database schema using AS/400 tools, CHGPRODCT converts logical fields to character fields. The PROATR and FRCCHG parameters do not prevent this from happening.
CAUSE:
If a logical field has been added through the Progress/400 Data Dictionary and then the table is modified with AS/400 tools the data type of the logical field will be changed.
DDS does not have a logical data type. When creating such a field through the Progress/400 data dictionary the Progress/400 DataServer uses a DDS type of character to represent the logical data type.
Since the AS/400 DDS description of a database file will include the character data type, using CHGPRODCT to update the DataServer will convert the field to character.
This is a known issue.
FIX:
Only maintain the database schema from the Progress/400 Data Dictionary (not on the AS/400 with AS/400 tools) and the problem will not arise.
Delete and Re-add the logical field through the Progress/400 data dictionary after running CHGPRODCT.