Progress
DataServer
for ODBC Guide


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_ALWAYS_INDEX
The value is either 1 for ON or 0 for OFF. The default value is 0. This option determines whether or not the DataServer should always order result sets. If this option is set to OFF, then queries that do not explicitly describe a desired ordering or that do not require ordering by Progress will return unordered results.
NOTE: The driver data source must be able to preserve cursors beyond a transaction boundary in order for you to be able to select the PRGRS_ALWAYS_INDEX option.

PRGS_CACHE_CONN

Specifies a maximum value to indicate the number of ODBC connections that can be cached without having to close existing connections. The default is 5.

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.
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.
PRGRS_PROC_TRAN
The value is either 1 for ON or 0 for OFF. Allows a stored procedure to run in a separate connection. This allows Progress to issue concurrent, active requests for running a stored procedure.
PRGRS_STABLE_CURS
The value is either 1 for ON or 0 for OFF. If you set the value to ON, the DataServer will try to reuse cursors across transaction boundaries.
NOTE: If this option is set to ON but the ODBC driver does not allow cursors to be reused, unpredictable results can occur.

PRGRS_WAIT_DELAY
Specifies the number of seconds to wait for a lock response from the driver when using the driver in asynchronous mode and NO–WAIT has been specified in a 4GL statement that requires a database lock.
The default value is 2.
NOTE: This option has no affect when running in synchronous mode.

The following example of the -Dsrv startup parameter sets the number of keys in the scrolling buffer to 100:

-Dsrv PRGRS_IDBUF,100 

Various sections in the “Using ODBC and DataServer Options” section discuss when and how to use these options.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095