Kbase P3959: No records are retrieved from the DB2/400 database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
FACT(s) (Environment):
IBM AS/400 (RISC)
Progress/400 DataServer
SYMPTOM(s):
No records are retrieved from the DB2/400 database
The Dictionary Library is maintained natively on AS/400
When trying to display records from the table using Procedure editor the table seems to be empty
CAUSE:
One of the most common cause of this issue is that the table which contains the data had the same name as a file already in the server schema. When the data file was added via CHGPRODCT, the utility created the P__FILE record with a different Progress name.
FIX:
Check P_FILE schema file to verify that the Progress name is the same as the physical file name that was in the code that did not return any records. If it is different then you either have to change your code or remove the entries (RMVSCHE) for both files and run CHGPRODCT again for the file which contains the data. If you remove schema entries, the schema holder needs to be resynchronized