Kbase P105767: Index and field name length truncated to 18 characters during protoodbc
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
7/6/2005 |
|
Status: Verified
FACT(s) (Environment):
IBM AS/400 (RISC)
OpenEdge 10.x
ODBC DataServer
SYMPTOM(s):
Index and field name length truncated to 18 characters
Warning messages during migration of Progress database to ODBC schema
WARNING: Index name too long. Name truncated to 18 characters.
WARNING: Field name <Long_Field_Name> is longer than the maximum legal identifier length of 18. Truncating field name to <Truncated_Name>
CAUSE:
Enhancement request# 20050624-012
FIX:
This Enhancement has not been implemented in the product.
Because both native Progress database and UDB/400 allow longer names the limit imposed by the DataServer layer (ProToOdb utility) should be lifted. It will be addressed in a future DataServer release.
Currently, the only way to avoid such situations is to adjust the index/field names before migration so as their length would be within the limit of 18 characters.