Customizing the Presto Environment

The Adapter for Presto provides several parameters for customizing the environment and optimizing performance.

Specifying a Timeout Limit

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

Issue the TIMEOUT Command

ENGINE SQLPRS SET TIMEOUT {nn|0}

where:

SQLPRS

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. 30 is the default value.

0

Represents an infinite period to wait for a response.

Cancelling Long Requests

You can cancel long running requests from the WebFOCUS Reporting Server browser interface. Depending on the capabilities of the native Presto driver, this action will either cancel the request entirely or break out of the fetch cycle.

Cancel Long Requests

    Procedure
  1. From the WebFOCUS Reporting Server browser interface 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.

Obtaining the Number of Rows Updated or Deleted

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 WebFOCUS Reporting Server browser interface by clicking Data Adapters on the menu bar, clicking a configured adapter, and choosing Change Settings from the menu. The Change Settings pane opens.

Obtain the Number of Rows Updated or Deleted

ENGINE SQLPRS SET PASSRECS {ON|OFF}

where:

SQLPRS

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.