Kbase P91111: For each query yields no records for the tables that have data in the DB2/400 database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/11/2004 |
|
Status: Unverified
FACT(s) (Environment):
Progress/400 DataServer
Progress/400 DataServer
IBM AS/400 (RISC)
SYMPTOM(s):
For each query yields no records for the tables that have data
The "for each" query does not have any index specified
No error message is displayed in the client
No error message recorded in the joblog
Performing the CHGPRODCT in the AS/400 server to update the dictionary library did not solve the problem
CHANGE:
Installed the Progress/400 DataServer license in the new upgraded machine
CAUSE:
The "ALLOW SELECT OMIT INDEXES" property in the PROSET file is on. By default the "ALLOW SELECT OMIT INDEXES" property is set to on in the PROSET file.
FIX:
Turn off the "ALLOW SELECT OMIT INDEXES" property in the PROSET file by placing an "N" for the value.
Here are the steps to edit the PROSET file:
1. In the command, type WRKOBJPDM PROGRESS and enter
2. Scroll to PROSET file and type 12 for the option and enter
3. Choose 18 to modify the file using DFU
4. Scroll to *ALLOW-SELECT-OMIT-INDEXE* settings and change the value to "N".
5. Pressing F3 key to exit will prompt you to save and press enter key.