Kbase P4845: Changing attribute "ALLOW-SELECT-OMIT-INDEXES" resolves issues with different record count against d
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress/400 DataServer
SYMPTOM(s):
A "FOR EACH" on a table yields a different record count with different indexes
DB2/400 database has *Select/Omit* logical files as indexes
CAUSE:
*Select/Omit* logical files cause the record count to be different
FIX:
Change the "ALLOW-SELECT-OMIT-INDEXES" attribute in the Progress setting file (PROSET) from Y (Yes) to N (no) to disallow "Select/Omit" Logical files as indexes with Progress applications.
Warning: Do not delete "Select/Omit" Logical files from the library.
Steps to do this:
1. Change the attribute called "ALLOW-SELECT-OMIT-INDEXES" from Y to N in the PROSET using DFU utility.
2. Perform DUPPRODB to create empty schema library.
3. Perform CHGPRODCT to add the DB2/400 database files to the empty library created in the step 2.
4. Synchronize the client.