CommitOnDisconnect – PB Docs 126

CommitOnDisconnect database parameter

Description

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

note.png When to specify CommitOnDisconnect

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

Controls

  • All database interfaces except
    SYJ

Syntax

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

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:


Document get from Powerbuilder help
Thank you for watching.
Was this article helpful?
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x