How to limit the number of records when they are queried from a pick applet
The 'Prefetch Size' and 'Max Cursor Size' is used for DB2 database. But there are some cases where Max Cursor Size alone has been used for Oracle database. The possible workaround is to run a default PDQ. You may like to default to a *No Records* Query using a search specification on an indexed field but with a value that we know does not exist. This will speed up performance for the first click. The user will then be required to query based on their criteria.