The DataServer keeps a cache of prepared SQL statements that it reuses with new parameters. This mechanism improves the DataServer performance. You can use the PRGRS_PREPCACHE option to manage this cache in two ways:
Some drivers might fail in reusing a prepared statement or in getting the second record for a particular query. Using -Dsrv PRGRS_PREPCACHE,0 instructs the DataServer to re-prepare each SQL statement.
Use the PRGRS_PREPCACHE option to control the size of the cache. The default cache size is 20 statements. You can increase the size for large applications that reuse many queries. The maximum size depends on the amount of resources you have available.
Some drivers might fail in reusing a prepared statement or in getting the second record for a particular query. Using -Dsrv PRGRS_PREPCACHE,0 instructs the DataServer to re-prepare each SQL statement.