In this section: |
The Adapter for Sybase provides several parameters for customizing the environment and optimizing performance. This topic provides an overview of customization options.
How to: |
The Adapter for Sybase has the ability to issue calls in NONBLOCK mode. The default behavior is BLOCK mode.
This feature allows the adapter to react to a client request to cancel a query while the adapter is waiting on engine processing. This wait state usually occurs during SQL parsing, before the first row of an answer set is ready for delivery to the adapter or while waiting for access to an object that has been locked by another application.
Tip: You can change this setting manually or from the Web Console by clicking Data Adapters on the menu bar, clicking a configured adapter, and choosing Change Settings from the menu. The Change Settings pane opens.
ENGINE SQLSYB SET NONBLOCK {0|n}
where:
Indicates the adapter. You can omit this value if you previously issued the SET SQLENGINE command.
Is a positive numeric number. 0 is the default value, which means that the adapter will operate in BLOCK mode. A value of 1 or greater activates the NONBLOCK calling and specifies the time, in seconds, that the adapter will wait between each time it checks to see if the:
Note: A value of 1 or 2 should be sufficient for normal operations.
How to: |
PASSRECS returns the number of rows affected by a successfully executed SQL Passthru INSERT, UPDATE, or DELETE command.
Tip: You can change this setting manually or from the Web Console by clicking Data Adapters on the menu bar, clicking a configured adapter, and choosing Change Settings from the menu. The Change Settings pane opens.
ENGINE SQLSYB SET PASSRECS {ON|OFF}
where:
Indicates the adapter. You can omit this value if you previously issued the SET SQLENGINE command.
Provides the number of rows affected in the application program SCB count member after the successful execution of an SQL Passthru INSERT, UPDATE, or DELETE command. ON is the default value.
Provides no information after the successful execution of an SQL Passthru INSERT, UPDATE, or DELETE command.
How to: |
You can control password encryption when the adapter connects to a Sybase ASE or Sybase IQ data source. By default, the password encryption is turned off. If you activate the PASSWORD_ENCRYPTION setting, all subsequent connections made by the Adapter for Sybase servers are affected.
Tip: You can change this setting manually or from the Web Console by clicking Data Adapters on the menu bar, clicking a configured adapter, and choosing Change Settings from the menu. When the Change Settings pane opens, choose OFF, ON, or EXTENDED from the pull-down list next to the PASSWORD_ENCRYPTION option.
SQL SQLSYB SET PASSWORD_ENCRYPTION {ON|EXTENDED|OFF}
where:
Sets the connection property CS_SEC_ENCRYPTION. Use this setting when you are only configuring for connections to a Sybase ASE data source.
Sets the connection property CS_SEC_EXTENDED_ENCRYPTION. Use this setting when you are only configuring for connections to a Sybase IQ data source or when you are configuring for connections to both Sybase ASE and Sybase IQ data sources.
Password encryption is disabled. OFF is the default setting.
iWay Software |