Kbase 16357: AS/400 How the primary index is chosen when creating schema
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
GOAL:
How the primary index is chosen when creating schema
FACT(s) (Environment):
Progress AS400 Dataserver
FIX:
When running CHGPRODCT to create the server schema for an AS/400 file, if the file has more than one index, Progress must choose one of them to be the primary index. They rules that apply are:
1. If the physical file contains an index, Progress chooses this one.
2. If the physical file doesn't contain any index, Progress chooses the first logical file. The first logical file is not the one which has less weight in a alphabetic sorting, but the one which appears in first place when you execute the DSPDBR command over the physical file.