Kbase P9193: Is there any limitation when adding indexes on AS400 ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
06/07/2005 |
|
Status: Verified
GOAL:
Is there any limitation when adding indexes on AS/400?
FACT(s) (Environment):
Progress 9.1x
Progress/400 DataServer
FIX:
Progress allows a maximum of 16 fields when defining an index. The Progress length of the combined fields that make up an index must be less than 200 bytes. The Progress/400 maximum length is some number less than 200, depending on the number of key fields used.