Administer Operator Categories and Custom Operator Groups › Configuring Operator Categories › Configure Databases: Default Sybase Properties

Configure Databases: Default Sybase Properties

You can configure the Databases category of operators for Sybase.

Follow these steps:

1. Click the Configuration tab, select Domain, and click Lock.
2. Click the Modules tab, right-click Databases, and select Edit.
3. Click the Default Sybase Properties tab.
4. Select one of the following values for the default Sybase relational database system:
   • Adaptive Server Anywhere (ASA)
   • Adaptive Server Enterprise (ASE)
5. Accept Tds or enter a different default connection protocol.
6. Accept com.sybase.jdbc2.jdbc.SybDriver or enter a different default driver.
7. Specify the location of the Sybase database.
   1. Identify the server host.
   2. Enter the default port.
8. Enter the default login credentials for the default Sybase database.
   1. Enter the default user name.
   2. Enter the password that is associated with the specified UserName.
9. Accept 10 as the default maximum number of rows to retrieve, or select another value up to 512.
10. Specify the amount of memory that the driver uses to cache insensitive result set data in one of the following ways:

    -1

    All data is cached.

    0

    Up to 2 GB of data is cached.

    n

    Defines the buffer size in KB, where the value is a power of 2 (an even number). When the specified limit is reached, the data is cached.

11. Indicate whether to use the JDBC v3.0 compliant mechanism as the default batch performance workaround.

    Note: If not selected, the native batch mechanism is used.

12. Click Save and Close.
13. Click Save.
14. Select Domain and click Unlock.

More information:

Override Settings Inherited by a Category of Operators

Category Configuration and Operator Inheritance

About Databases

Configuring Operator Categories