Kbase P59286: Progress object names containing more than 10 characters are truncated for the Foreign name in the D
| 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
SYMPTOM(s):
Progress object names containing more than 10 characters are truncated for the Foreign name in the DDS on the AS/400
When migrating Progress DB to AS/400 using Progress/400 Data Dictionary, any Progress object name containing more than 10 characters get truncated on AS/400 side
The server schema and schema holder contain the Full Progress Name of the original object.
It is not possible to access objects using long names (alias) via AS/400 HLL program
CAUSE:
This is expected behavior. By default Progress/400 DataServer creates DDS description of each physical file that corresponds to a Progress table without the ALIAS keyword. The compiled physical file is generated without field alias' and that's why it cannot be referenced by AS/400 tools or programs.
FIX:
If using Progress/400 DataServer 9.1C the PROSET file can be modified to tell the DataServer to generate DDS descriptions with the ALIAS keyword by changing the "BUILD-DDS-ALIAS-KEYWORD" parameter to "Y".
All other versions of Progress/400 are restricted to the maximum of 10 characters for foreign object names.