Setting database preferences

How to set

The way you set connection-related database preferences in PowerBuilder varies, as summarized in the following table (AutoCommit and Lock are the only database preferences that you can set in a PowerBuilder application script).

**Table 13-1: Database preferences and where they can be set**
Database preference	Set in development environment by editing	Set in PowerBuilder application by editing
AutoCommit	Database Profile Setup dialog box for your connection	Application script
Lock	Database Profile Setup dialog box for your connection	Application script
Shared Database Profiles	Database Preferences property sheet	—
Connect to Default Profile	Database Preferences property sheet	—
Read Only	Database Preferences property sheet	—
Keep Connection Open	Database Preferences property sheet	—
Use Extended Attributes	Database Preferences property sheet	—
SQL Terminator Character	Database Preferences property sheet	—

The following sections give the steps for setting database preferences in the development environment and (for AutoCommit and Lock) in a PowerBuilder application script.

For more information

For information about using a specific database preference, see its description in the online Help.