HomePowerBuilderAppeon Documentation Center

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

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.


Default value

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

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 page in the Database Profile Setup dialog box.

  • Application

    Type the following in code:

    SQLCA.DBParm="CommitOnDisconnect='No'"
Prev  Up  Next
CommandTimeout  Home  ConnectAs