Customizing the Sybase Environment

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.


Top of page

x
Activating NONBLOCK Mode

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.



x
Syntax: How to Activate NONBLOCK Mode
ENGINE SQLSYB SET NONBLOCK {0|n}

where:

SQLSYB

Indicates the adapter. You can omit this value if you previously issued the SET SQLENGINE command.

n

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:

  • Query has been executed.
  • Client application has requested the cancellation of a query.
  • Kill Session button on the Web Console is pressed.

Note: A value of 1 or 2 should be sufficient for normal operations.


Top of page

x
Obtaining the Number of Rows Updated or Deleted

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.



x
Syntax: How to Obtain the Number of Rows Updated or Deleted
ENGINE SQLSYB SET PASSRECS {ON|OFF}

where:

SQLSYB

Indicates the adapter. You can omit this value if you previously issued the SET SQLENGINE command.

ON

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.

OFF

Provides no information after the successful execution of an SQL Passthru INSERT, UPDATE, or DELETE command.


Top of page

x
Enabling Password Encryption for Sybase ASE and IQ

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.



x
Syntax: How to Enable Password Encryption (ASE and IQ)
SQL SQLSYB SET PASSWORD_ENCRYPTION {ON|EXTENDED|OFF}

where:

ON

Sets the connection property CS_SEC_ENCRYPTION. Use this setting when you are only configuring for connections to a Sybase ASE data source.

EXTENDED

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.

  • The property CS_SEC_EXTENDED_ENCRYPTION is available starting with Sybase Open Client version 15 ESD #7. If this value is not available for the given client version (that is, a client version earlier than Sybase Open Client version 15 ESD #7), the error message FOC1811 will be produced at the time of the setting and at the time of a connection attempt. (Other possible errors that may occur if the user's version of Open Client is earlier than 15 ESD #7 include the following: SQLCODE IS 5; ct_con_props(): User API layer: external error: An illegal value of 9213 given for parameter property.)
  • Sybase IQ supports only CS_SEC_EXTENDED_ENCRYPTION. A Sybase error message will result if a connection to an IQ server is attempted with the value ON in effect: SQLCODE IS 4002; ASA Error -103: Invalid user ID or password.
OFF

Password encryption is disabled. OFF is the default setting.


iWay Software