Kbase 16064: Complex query without SCROLLING AS/400 7.3C20 DataServer
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
SUMMARY:
AS/400 DataServer 7.3C20-- New Feature for running Complex Query
If you issue a query against a table with multiple indexes and those
indexes are used to resolve the query, Progress/400 could return the
wrong set of records or none at all. It is possible that you are
experiencing this problem and are not aware of it. You can now detect
this problem or ignore the problem by using the -Dsrv Parameter in
your connect statement.
-Dsrv QBSFGE=0 this setting will cause an error dialog to be dislayed
-Dsrv QBSFGE=1 will by pass the error dialog and continue to process.
The default is set to (0) zero.
V8.1 Client will resolve this query but, you may noticed a degrade in
performance.
Creating a Logical File on the AS/400 specifying the key fields as
those used in the query will improve this. The new logical view will
automatically be used whent he query is run.