Advanced Parameters

Edit the Advanced parameters optional fields that affect performance and use of resources in the odbc.ini file.

These default values for the Advanced parameters are sufficient for most DB2 UDB installations.

Parameter	Comments
AlternateID	A value that is substituted at connect time for the current schema. This sets the default qualifier for unqualified object names in SQL statements. If the attempt to change current schema fails, the connection fails with `Invalid value for Alternate ID`. DB2 permissions should be set to SYSADM. (Not valid for AS/400 V5R1.)
WithHold	The cursor behavior for the application used with this data source—either DB2 closes all open cursors (Delete cursors) after a commit or rollback, or leaves them open (Preserve cursors). When this option is 1 (the default), the cursor behavior is Preserve. Sybase recommends this option. When this option is 0, the cursor behavior is Delete.
AddStringToCreate Table	Use this parameter to append the in tablespace clause to create table commands.