Customizing the Microsoft SQL Server ODBC Environment

In this section:

The Adapter for Microsoft SQL Server ODBC provides several parameters for customizing the environment and optimizing performance. This topic provides an overview of customization options.


Top of page

x
Specifying a Timeout Limit

How to:

TIMEOUT specifies the number of seconds the adapter will wait for a response after you issue an SQL request to Microsoft SQL Server.



x
Syntax: How to Issue the TIMEOUT Command
ENGINE MSODBC SET TIMEOUT {nn|0}

where:

MSODBC

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

nn

Is the number of seconds before a time-out occurs. 30 is the default value.

0

Represents an infinite period to wait for a response.


Top of page

x
Cancelling Long Requests

How to:

You can cancel long running requests from the Web Console. Depending on the capabilities of the native JDBC driver, this action will either cancel the request entirely or break out of the fetch cycle.



x
Procedure: How to Cancel Long Requests
  1. From the Web Console menu bar choose Workspace, Configuration/Monitor, Java Services, DEFAULT. Right-click on DEFAULT and select Agents.
  2. In the Java Services Agents pane, highlight a row with the jscomid you wish to kill, right-click on it and select Stop.

Top of page

x
Specifying the Login Wait Time

How to:

You can use the LOGINTIMEOUT command to specify the number of seconds the adapter will wait for a response from Microsoft SQL Server at connect time.

Note: For compatibility with previous releases of the adapter, TIMEOUT is available as a synonym for LOGINTIMEOUT.



x
Syntax: How to Specify the Login Wait Time
ENGINE MSODBC SET LOGINTIMEOUT|TIMEOUT {nn|0}

where:

MSODBC

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

nn

Is the number of seconds before a timeout occurs. The default value is approximately 15 seconds.

0

Represents an infinite period to wait for login response.


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 Adapters on the menu bar, clicking a configured adapter, and choosing Change Settings from the right-click menu. The Change Settings pane opens.

x



x
Syntax: How to Obtain the Number of Rows Updated or Deleted

The available parameters are:

ENGINE MSODBC SET PASSRECS {ON|OFF}

where:

MSODBC

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
Specifying the Transaction Isolation Level

How to:

You can specify the transaction isolation level from the Web Console or using the SET ISOLATION command.

x



x
Syntax: How to Specify Transaction Isolation Level From a SET Command

You can specify transaction isolation level by issuing the following command

ENGINE MSODBC SET ISOLATION {RU|RC|RR|SE|CH|CS}

where:

RU

Sets the transaction isolation level to Read Uncommitted.

RC

Sets the transaction isolation level to Read Committed.

RR

Sets the transaction isolation level to Repeatable Read.

SE

Sets the transaction isolation level to Serializable Read.

CH

Sets the transaction isolation level to Chaos.

CS

Sets the transaction isolation level to Cursor Stability, which is a synonym for Read Committed.


WebFOCUS