|
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 OpenEdge 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 error handling behavior occurs (that is, OpenEdge waits and retries rather than halting). Valid values are native ODBC data-source error message numbers.
|
|
PRGRS_MAPFIXEDCHAR
|
For foreign data types that map to the ODBC SQL_TYPE_CHARACTER fixed length data type, this parameter specifies that white space data should be trimmed from the right or trailing side of a non-white space character value in a result set. Since the OpenEdge CHARACTER data type to which the SQL_TYPE_CHARACTER fixed length type maps is variable in length, it makes sense to trim the padded white space at the end of the fixed area, truncating the server value and NULL terminating that truncated value. Progress recommends you specify this value if the trailing white space in the fixed length character field is not significant to your server's data values or the value you need to receive into the OpenEdge client application.
|
|
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, OpenEdge 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 OpenEdge 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 the asynchronous mode and when NO–WAIT is specified in an ABL statement that requires a database lock.The default value is 2.
Note: This option has no affect on the DataServer when running in synchronous mode.
|
|
PRGRS_QUOTE_PROCTEXT
|
Specifies how the DataServer accesses result sets available through proc-text-buffer in which each row is a long character string. You can activate or deactivate the quoting behavior in the proc-text-buffer result sets using this option.
The default value of the PRGRS_QUOTE_PROCTEXT option is 1, which indicates that the quoting behavior is active for the result sets.
You can deactivate the quoting behavior by setting the PRGRS_QUOTE_PROCTEXT option to 0.
For more information on PROC-TEXT-BUFFER and PROC-TEXT-BUFFER-Q, see Retrieving data-source results.
|
|
-Dsrv PRGRS_IDBUF,100
|