Reporting Server > Using the Adapter for Microsoft Azure SQL Data Warehouse > Customizing the Microsoft Azure SQL Data Warehouse Environment

Customizing the Microsoft Azure SQL Data Warehouse Environment

Topics:

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

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 Azure SQL.

Syntax: How to Issue the TIMEOUT Command 

ENGINE SQLADW SET TIMEOUT {nn|0}

where:

SQLADW

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.

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.

Procedure: How to Cancel Long Requests

  1. From the Web Console sidebar choose Workspace. In the navigation pane, expand Java Services. Right-click DEFAULT and select Agents.
  2. In the Java Services Agents pane, highlight a row with the jscomid you wish to kill, right-click it, and select Stop.

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 Azure SQL at connect time.

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

Syntax: How to Specify the Login Wait Time 

ENGINE SQLADW SET LOGINTIMEOUT|TIMEOUT {nn|0}

where:

SQLADW

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.

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

x

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

The available parameters are: 

ENGINE SQLADW SET PASSRECS {ON|OFF}

where:

SQLADW

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.

WebFOCUS

Feedback