Setting database preferences

The way you set connection-related database preferences in DataWindow Designer varies, as summarized in the following table.

**Table 12-1: Database preferences and where they can be set**
Database preference	Set in plug-in by editing
AutoCommit	Database Profile Setup dialog box for your connection
Lock	Database Profile Setup dialog box for your connection
Shared Database Profiles	Database Preferences dialog box
Connect DB at Startup	Database Preferences dialog box
Connect to Default Profile	Database Preferences dialog box
Read Only	Database Preferences dialog box
Keep Connection Open	Database Preferences dialog box
Use Extended Attributes	Database Preferences dialog box
SQL Terminator Character	Database Preferences dialog box

The following sections give the steps for setting database preferences in the plug-in.

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