Sybase Parameters

Inherit Settings

If checked, values shown reflect the current values of the Domain. At runtime, the values are selected from the Environment (if defined).

Default Server Type

Specifies one of the following Sybase server types:

Default Connection Protocol

Specifies the default connection protocol. The default value is Tds.

Default Driver

Specifies the default Sybase driver. The default value is com.sybase.jdbc2.jdbc.SybDriver.

Default Server Host

Specifies the host were Sybase is running.

Default Server Port

Specifies the default Sybase server port.

Default UserName

Specifies the default Sybase username.

Default Password

Specifies the password for the Sybase user.

Default Maximum Rows

Specifies the maximum number of rows to retrieve. If blank, the default value is 10 rows.

Default Cache Buffer Size

The Sybase Cache Buffer Size is the amount of memory used by the driver to cache insensitive result set data. Valid values are:

-1 = All data is cached.

0 = All data is cached up to 2GB.

X = Must be positive. This is the buffer size (must be a power of 2). This value is specified in KB.

After the limit is reached (if any), the result set data is written to disk.

Default Batch Performance Workaround

The Sybase batch performance workaround is one of the following: