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.
When to specify CommitOnDisconnect
You must specify a value for CommitOnDisconnect before connecting
to the database.
Controls
-
All database interfaces except
SYJ
Syntax
|
1 |
CommitOnDisconnect='<span>value</span>' |
|
Parameter |
Description |
|---|---|
|
value |
Specifies whether PowerBuilder should commit
|
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:
1SQLCA.DbParameter="CommitOnDisconnect='No'"