DataServer Options
In addition to the ODBC-defined options, the DataServer provides a number of -Dsrv options that are defined on the DataServer side of a connection. Each DataServer option has a name of the form PRGRS_option–name, to reflect its origin. Table 6–2 lists and describes these options.
Table 6–2: DataServer Options
Option
|
Description
|
PRGRS_CONNECT
|
Passes a connection string to the ODBC driver.
|
PRGRS_IDBUF
|
Specifies the number of keys in the scrolling buffer. The value must be greater than 0. The default value is 25 keys. This parameter applies to all nonlookahead cursors.
|
PRGRS_LOCK_ERRORS
|
Specifies that when an application gets the stated error message, standard Progress error-handling behavior occurs (that is, Progress waits and retries rather than halting). Valid values are native ODBC data source error message numbers.
|
PRGRS_MINBUF
|
Specifies the minimum size of the buffer used to get data from the DataServer. Use this keyword only with drivers that fail to fetch large records. The default value is 500 bytes. If you specify a value smaller than the default, Progress uses the default value.
|
PRGRS_NO_INDEX
|
Suppresses index creation at schema import time. If you specify a value of 1 for -Dsrv PRGRS_NO_INDEX, you must create the indexes manually in the schema holder.
|
PRGRS_PREPCACHE
|
Specifies the maximum number of prepared statements to be kept in cache. The default value is 20 statements.
|
The following example of the -Dsrv startup parameter sets the number of keys in the nonlookahead scrolling buffer to 100:
See the "Using SQL Server™ and DataServer Options" section for information on when and how to use these options.