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.
Applies to
All database interfaces
Syntax
|
1 |
CommitOnDisconnect='value' |
|
Parameter |
Description |
|---|---|
|
value |
Specifies whether PowerBuilder should commit or
|
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:
1SQLCA.DBParm="CommitOnDisconnect='No'"