Kbase P66678: Field names are assigned the DDS Alias name after CHGPRODCT
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
FACT(s) (Environment):
IBM AS/400 (RISC)
Progress/400 DataServer
Progress 9.x
SYMPTOM(s):
Field names are assigned the DDS Alias name after CHGPRODCT
Field names are referenced by long names after CHGPRODCT
Dictionary library is maintained on AS/400
After running CHGPRODCT against a newly generated physical file (table) and synchronizing the schema holder on the client, the field names visible in Data Dictionary are referenced by their long names.
CAUSE:
This is expected behavior.
When CHGPRODCT is executed against the physical file including fields' aliases this information is put into the server schema (column FIELDNAME of the P__FIELD file).
FIX:
Ensure that the physical files to be added to the schema don't contain the ALIAS keyword for their fields unless this behavior is required.