Setting AutoCommit and Lock in a PowerBuilder application
script
Contents
If you are developing a PowerBuilder application that connects to
a database, you must specify the required connection parameters in the
appropriate script as properties of the default Transaction object
(SQLCA) or a Transaction object that you create. For example, you might
specify connection parameters in the script that opens the
application.
AutoCommit and Lock are properties of SQLCA. As such, they are the
only database preferences you can set in a PowerBuilder script. You can
do this by:
-
(Recommended) Copying PowerScript syntax for AutoCommit and
Lock from the Preview tab in the Database Profile Setup dialog box
into your script -
Coding PowerScript to set values for the AutoCommit and Lock
properties of the Transaction object -
Reading AutoCommit and Lock values from an external text
file
For more about using Transaction objects to communicate with a
database in a PowerBuilder application, see the section called “Using Transaction Objects” in Application Techniques.