Description

The Sybase Net-Gateway for DB2 interface in PowerBuilder and InfoMaker now supports the AutoCommit SQLCA property. This support is new in Version 6.0.

AutoCommit is supported only when you are using Sybase Net-Gateway Version 3.0 or higher. It is not supported with earlier versions of Sybase Net-Gateway.

Purpose

The AutoCommit setting controls whether PowerBuilder or InfoMaker issues SQL statements inside or outside the scope of a transaction. When AutoCommit is set to False (the default), SQL statements are issued inside the scope of a transaction. When AutoCommit is set to True, SQL statements are issued outside the scope of a transaction.

• For more information, see the description of AutoCommit in Connecting to Your Database.

Usage

As with any other DBParm parameter, you can set AutoCommit in the Database Profile Setup dialog box for your connection or in a PowerBuilder application script.

Examples

To tell PowerBuilder or InfoMaker to issue SQL statements outside the scope of a transaction, set AutoCommit to True in either of the following ways:

• To set AutoCommit in the Database Profile Setup dialog box:

Select the AutoCommit Mode checkbox on the Connection tab in the Database Profile Setup dialog box.

• To set AutoCommit in a PowerBuilder application script:

Type the following in a PowerBuilder script:

SQLCA.AutoCommit = True

If you select the AutoCommit Mode checkbox in your database profile, this syntax displays on the Preview tab in the Database Profile Setup dialog box. You can then copy the syntax from the Preview tab into your script and modify the default transaction object name (SQLCA) if necessary.