CommitOnDisconnect

Description

Specifies whether PowerBuilder should commit (the default) or roll back all previously uncommitted database updates before disconnecting from a data source.

When to specify CommitOnDisconnect You must specify a value for CommitOnDisconnect before connecting to the database.

Applies to

All database interfaces except SYJ

Syntax

CommitOnDisconnect = 'value'

Parameter	Description
value	Specifies whether PowerBuilder should commit or roll back all previously uncommitted database updates before disconnecting from a data source. Values are: Yes (Default) PowerBuilder commits all uncommitted database updates when an application closes or when an explicit DISCONNECT statement is issued in code. No PowerBuilder rolls back all uncommitted database updates when an application closes or when an explicit DISCONNECT statement is issued in code. With this setting, PowerBuilder does not automatically commit updates when you disconnect from the database.

Parameter

Description

value

Specifies whether PowerBuilder should commit or roll back all previously uncommitted database updates before disconnecting from a data source. Values are:

Yes (Default) PowerBuilder commits all uncommitted database updates when an application closes or when an explicit DISCONNECT statement is issued in code.
No PowerBuilder rolls back all uncommitted database updates when an application closes or when an explicit DISCONNECT statement is issued in code. With this setting, PowerBuilder does not automatically commit updates when you disconnect from the database.

Default

CommitOnDisconnect = 'Yes'

Usage

Set CommitOnDisconnect to No if you want PowerBuilder to roll back uncommitted database updates (instead of automatically committing them when you disconnect from the database).

Examples

Example 1

To tell PowerBuilder to roll back uncommitted database updates instead of committing them when disconnecting from the database:

Database profile Clear the Commit On Disconnect check box on the Connection tab in the Database Profile Setup dialog box.

Application Type the following in code:

SQLCA.DBParm = "CommitOnDisconnect='No'"