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 Application Techniques.
