Customizing the Adapter for the MariaDB Environment

Topics:

x

This topic describes how to set the adapter for the MariaDB environment.

PASSRECS

How to:

x

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.

Syntax: How to Set PASSRECS

ENGINE SQLMAR SET PASSRECS {ON|OFF}

where:

SQLMAR

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.

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

WebFOCUS

Feedback