Expert Settings Overview

From the Expert panel, you can quickly access and set all of the data source settings that can be modified by a user. These include all of the settings that can be configured from the other panels in the wizard as well as those that are accessible only from the Expert Page.

To configure a setting from the Expert Page:

  1. From the Data Source Entry list box, select the name of the data source setting that you want to modify .

  2. In the Values list, either choose or type an appropriate value for the corresponding setting.

The following links offer specific information about each data source setting.

AccessFix1

Description

QryBufSiz

Accessible Tables

FetchAhead

ReadOnly

Accounting

FoldUIDPWD

Server

AllowSynonyms

GetInfoCatalogUsage

SpecialColumns

AlwaysWide

HeldCursors

StrictParsing

AutoBind

HideTsScale

TimeStampAsChar

AutoSqlSet

HostName

TrustedConnection

AutoTypDefOvr

IncludeSynonyms

TwoPC

BinaryCCSID

IsolationLevel

TypDefOvr

BindRules

KeepDynamic

UID

CacheUID

LongStrParams

UseDSCRDBTBL

CatFilters

MaxRows

UseDynamicCatalogSQL

CatQual

OverrideCodeset

UseEncryption

CharacterSubstitution

PkgCollD

UseJumboPackages

CreateTable

PkgOwnID

UseSYSDUMMYAEU

CustomizePrdid

Port

 

DefaultQualifier