CLI/ODBC configuration keywords listing by category
Categorized list of CLI configuration keywords
The CLI/ODBC configuration
keywords are divided into the listed categories:
- Compatibility configuration keywords
- Data source configuration keywords
- Data type configuration keywords
- Enterprise configuration keywords
- Environment configuration keywords
- File DSN configuration keywords
- Optimization configuration keywords
- Service configuration keywords
- Static SQL configuration keywords
- Transaction configuration keywords
You can set most CLI/ODBC
configuration keywords in the db2cli.ini initialization
file or by providing the keyword information in the connection string
to the SQLDriverConnect()
function.
However, you can set the Trusted_Connection keyword
only with theSQLDriverConnect()
function.
Compatibility configuration keywords
Use
the compatibility configuration keywords to define Db2® behavior.
You can set the compatibility configuration keywords to ensure that
other applications are compatible with Db2.
- AllowInterleavedGetData CLI/ODBC configuration keyword
- CheckForFork CLI/ODBC configuration keyword
- CursorTypes CLI/ODBC and IBM data server driver driver configuration keyword
- DeferredPrepare CLI/ODBC and IBM data server driver configuration keyword
- DescribeCall CLI/ODBC and IBM data server driverconfiguration keyword
- DescribeParam CLI/ODBC and IBM data server driver configuration keyword
- DisableKeysetCursor CLI/ODBC and IBM data server driver configuration keyword
- DisableMultiThread CLI/ODBC configuration keyword
- DisableUnicode CLI/ODBC configuration keyword
- EnableNamedParameterSupport CLI/ODBC and IBM data server driver configuration keyword
- OleDbReportIsLongForLongTypes CLI/ODBC and IBM data server driver configuration keyword
- OleDbSQLColumnsSortByOrdinal CLI/ODBC and IBM data server driver configuration keyword
- RetCatalogAsCurrServer CLI/ODBC and IBM data server driver configuration keyword
- RetOleDbConnStr CLI/ODBC and IBM data server driver configuration keyword
- TimestampTruncErrToWarning CLI/ODBC configuration keyword
- TLSVersion CLI/ODBC configuration keyword
- Trusted_Connection CLI/ODBC and IBM data server driver configuration keyword (use
SQLDriverConnect()
to set this keyword)
Data source configuration keywords
General
keywords associated with a data source configuration.
Data type configuration keywords
Use
the data type configuration keywords to define how Db2 reports
and handles various data types.
- BitData CLI/ODBC and IBM data server driver configuration keyword
- CurrentImplicitXMLParseOption CLI/ODBC and IBM data server driver configuration keyword
- DateTimeStringFormat CLI/ODBC configuration keyword
- DecimalFloatRoundingMode CLI/ODBC configuration keyword
- FloatPrecRadix CLI/ODBC and IBM data server driver configuration keyword
- Graphic CLI/ODBC and IBM data server driver configuration keyword
- LOBMaxColumnSize CLI/ODBC configuration keyword
- LongDataCompat CLI/ODBC and IBM data server driver configuration keyword
- MapBigintCDefault CLI/ODBC and IBM data server driver configuration keyword
- MapCharToWChar CLI/ODBC and IBM data server driver configuration keyword
- MapDateCDefault CLI/ODBC and IBM data server driver configuration keyword
- MapDateDescribe CLI/ODBC and IBM data server driver configuration keyword
- MapDecimalFloatDescribe CLI/ODBC and IBM data server driver configuration keyword
- MapGraphicDescribe CLI/ODBC and IBM data server driver IBM data server driver configuration keyword
- MapTimeCDefault CLI/ODBC and IBM data server driver configuration keyword
- MapTimeDescribe CLI/ODBC and IBM data server driver configuration keyword
- MapTimestampCDefault CLI/ODBC and IBM data server driver configuration keyword
- MapTimestampDescribe CLI/ODBC and IIBM data server driver configuration keyword
- MapXMLCDefault CLI/ODBC and IBM data server driver configuration keyword
- MapXMLDescribe CLI/ODBC and IBM data server driver configuration keyword
- OleDbReturnCharAsWChar CLI/ODBC and IBM data server driver configuration keyword
- PromoteLONGVARtoLOB CLI/ODBC and IBM data server driver configuration keyword
- XMLDeclaration CLI/ODBC and IBM data server driver configuration keyword
Enterprise configuration keywords
Use
the enterprise configuration keywords to maximize the efficiency of
connections to large databases.
- CLIPkg CLI/ODBC and IBM data server driver configuration keyword
- ConnectNode CLI/ODBC and IBM data server driver configuration keyword
- CurrentPackagePath CLI/ODBC configuration keyword
- CurrentPackageSet CLI/ODBC configuration keyword
- CurrentRefreshAge CLI/ODBC configuration keyword
- CurrentSchema CLI/ODBC configuration keyword
- CurrentSQLID CLI/ODBC configuration keyword
- DBName CLI/ODBC and IBM data server driver configuration keyword
- ExtendedTableInfo CLI/ODBC configuration keyword
- GranteeList CLI/ODBC and IBM data server driver configuration keyword
- GrantorList CLI/ODBC and IBM data server driver configuration keyword
- OnlyUseBigPackages CLI/ODBC and IBM data server driver configuration keyword
- ReportPublicPrivileges CLI/ODBC and IBM data server driver configuration keyword
- ReturnSynonymSchema CLI/ODBC and IBM data server driver configuration keyword
- SchemaList CLI/ODBC and IBM data server driver configuration keyword
- ServerMsgMask CLI/ODBC and IBM data server driver configuration keyword
- ServerMsgTextSP CLI/ODBC and IBM data server driver configuration keyword
- SQLCODEMAP CLI/ODBC configuration keyword
- SysSchema CLI/ODBC and IBM data server driver configuration keyword
- TableType CLI/ODBC and IBM data server driver configuration keyword
- UseServerMsgSP CLI/ODBC and IBM data server driver configuration keyword
Environment configuration keywords
Use
the environment configuration keywords to define environment-specific
settings, such as the location of various files on the server and
client machines.
- ClientGSKitLocation CLI/ODBC and IBM data server driver configuration keyword
- ConnectTimeout /ODBC and IBM data server driver configuration keyword
- CurrentFunctionPath CLI/ODBC configuration keyword
- Interrupt CLI/ODBC and IBM data server driver configuration keyword
- QueryTimeoutInterval CLI/ODBC configuration keyword
- ReadCommonSectionOnNullConnect CLI/ODBC configuration keyword
- ReadOnlyConnection CLI/ODBC configuration keyword
- ReceiveTimeout CLI/ODBC configuration keyword
- TempDir CLI/ODBC and IBM data server driver configuration keyword
File DSN configuration keywords
Use
the File DSN configuration keywords to set the TCP/IP settings for
a file DSN connection.
- AltHostName CLI/ODBC and IBM data server driver configuration keyword
- AltPort CLI/ODBC and configuration keyword
- Attach CLI/ODBC configuration keyword
- Authentication CLI/ODBC configuration keyword
- BIDI CLI/ODBC configuration keywordBIDI CLI/ODBC and IBM data server driver configuration keyword
- Database CLI/ODBC configuration keyword
- DSN CLI/ODBC configuration keyword
- FileDSN CLI/ODBC configuration keyword
- Hostname CLI/ODBC configuration keyword
- Instance CLI/ODBC and IBM data server driver configuration keyword
- KRBPlugin CLI/ODBC configuration keyword
- Port CLI/ODBC configuration keyword
- Protocol CLI/ODBC and IBM data server driver configuration keyword
- PWDPlugin CLI/ODBC configuration keyword
- ServiceName CLI/ODBC and IBM data server driver configuration keyword
- Security CLI/ODBC and IBM data server driver configuration keyword
- SSLClientLabel CLI/ODBC configuration keyword
- SSLClientKeystash CLI/ODBC configuration keyword
- SSLClientKeystoredb CLI/ODBC configuration keyword
- SSLClientKeystoreDBPassword CLI/ODBC configuration keyword
- SSLServerCertificate CLI/ODBC configuration keywordTargetPrincipal CLI/ODBC configuration keyword
Optimization configuration keywords
Use
the optimization configuration keywords to speed up and reduce the
amount of network flow between the IBM Data
Server Driver for ODBC and CLI and the server.
- AllowGetDataLOBReaccess CLI/ODBC configuration keyword
- AppendForFetchOnly CLI/ODBC and IBM data server driver configuration keyword
- AppUsesLOBLocator CLI/ODBC and IBM data server driver configuration keyword
- BlockForNRows CLI/ODBC and IBM data server driver configuration keyword
- CacheUsrLibL CLI/ODBC configuration keyword
- BlockLobs CLI/ODBC and IBM data server driver configuration keyword
- ClientBuffersUnboundLOBS CLI/ODBC and IBM data server driver configuration keyword
- ColumnwiseMRI CLI/ODBC configuration keyword
- ConcurrentAccessResolution CLI/ODBC configuration keyword
- CurrentMaintainedTableTypesForOpt CLI/ODBC and IBM data server driver configuration keyword
- CURRENTOPTIMIZATIONPROFILE CLI/ODBC and IBM data server driver configuration keyword
- DB2Degree CLI/ODBC and IBM data server driver configuration keyword
- DB2Explain CLI/ODBC configuration keyword
- DB2NETNamedParam CLI/ODBC configuration keyword
- DB2Optimization CLI/ODBC and IBM data server driver configuration keyword
- DescribeInputOnPrepare CLI/ODBC and IBM data server driver configuration keyword
- DescribeOutputLevel CLI/ODBC and IBM data server driver configuration keyword
- FET_BUF_SIZE CLI/ODBC and IBM data server driver configuration keyword
- GetDataLobNoTotal CLI/ODBC and IBM data server driver configuration keyword
- KeepDynamic CLI/ODBC and IBM data server driver configuration keyword
- LOBCacheSize CLI/ODBC configuration keyword
- LOBFileThreshold CLI/ODBC and IBM data server driver configuration keyword
- LockTimeout CLI/ODBC configuration keyword
- MaxBlkExt CLI/ODBC and IBM data server driver configuration keyword
- MaxLOBBlockSize CLI/ODBC and IBM data server driver configuration keyword
- OptimizeForNRows CLI/ODBC and IBM data server driver configuration keyword
- QueryPrefetch CLI/ODBC configuration keyword
- Reopt CLI/ODBC and IBM data server driver configuration keyword
- RetryOnMERGE CLI/ODBC configuration keyword
- ReturnAliases CLI/ODBC and IBM data server driver configuration keyword
- SkipTrace CLI/ODBC configuration keyword
- StmtConcentrator CLI/ODBC and IBM data server driver configuration keyword
- StreamGetData CLI/ODBC and IBM data server driver configuration keyword
- StreamOutputLOBonCall CLI/ODBC configuration keyword
- StreamPutData CLI/ODBC configuration keyword
- Underscore CLI/ODBC and IBM data server driver configuration keyword
Service configuration keywords
Use
the service configuration keywords to help in troubleshooting problems
with CLI/ODBC
connections. Programmers can also use service configuration keywords
to gain a better understanding of how their CLI programs
are translated into calls to the server.
- AppendAPIName CLI/ODBC and IBM data server driver configuration keyword
- AppendRowColToErrorMessage CLI/ODBC and IBM data server driver configuration keyword
- DiagLevel CLI/ODBC configuration keyword
- DiagPath CLI/ODBC configuration keyword
- IgnoreWarnings CLI/ODBC and IBM data server driver configuration keyword
- IgnoreWarnList CLI/ODBC and IBM data server driver configuration keyword
- LoadXAInterceptor CLI/ODBC and IBM data server driver configuration keyword
- NotifyLevel CLI/ODBC configuration keyword
- Patch1 CLI/ODBC and IBM data server driver configuration keyword
- Patch2 CLI/ODBC and IBM data server driver configuration keyword
- ReportRetryErrorsAsWarnings CLI/ODBC and IBM data server driver configuration keyword
- RetryParameterBindingOnError CLI/ODBC configuration keyword
- RetryOnError CLI/ODBC and IBM data server driver configuration keyword
- ProgramID CLI/ODBC configuration keyword
- ProgramName CLI/ODBC configuration keyword
- SaveFile CLI/ODBC configuration keyword
- Trace CLI/ODBC configuration keyword
- TraceAPIList CLI/ODBC configuration keyword
- TraceAPIList! CLI/ODBC configuration keyword
- TraceComm CLI/ODBC configuration keyword
- TraceErrImmediate CLI/ODBC configuration keyword
- TraceFileName CLI/ODBC configuration keyword
- TraceFlush CLI/ODBC configuration keyword
- TraceFlushOnError CLI/ODBC configuration keyword
- TraceLocks CLI/ODBC configuration keyword
- TracePathName CLI/ODBC configuration keyword
- TracePIDList CLI/ODBC configuration keyword
- TracePIDTID CLI/ODBC configuration keyword
- TraceRefreshInterval CLI/ODBC configuration keyword
- TraceStmtOnly CLI/ODBC configuration keyword
- TraceTime CLI/ODBC configuration keyword
- TraceTimestamp CLI/ODBC configuration keyword
- WarningList CLI/ODBC and IBM data server driver configuration keyword
Static SQL configuration keywords
Use
the static SQL configuration keywords when running static SQL statements
in CLI/ODBC
applications.
Transaction configuration keywords
Use
the transaction configuration keywords to control and speed up SQL
statements that are used in the application.
- ArrayInputChain CLI/ODBC configuration keyword
- AsyncEnable CLI/ODBC configuration keyword
- AutoCommit CLI/ODBC and IBM data server driver configuration keyword
- ClientAcctStr CLI/ODBC and IBM data server driver configuration keyword
- ClientApplName CLI/ODBC and IBM data server driver configuration keyword
- ClientCorrelationToken CLI/ODBC configuration keyword
- ClientUserID CLI/ODBC configuration keyword
- ClientWrkStnNameCLI/ODBC and IBM data server driver configuration keyword
- CommitOnEOF CLI/ODBC configuration keyword
- ConnectType CLI/ODBC and IBM data server driverconfiguration keyword
- CursorHold CLI/ODBC and IBM data server driver configuration keyword
- Mode CLI/ODBC and IBM data server driver configuration keyword
- SQLOverrideFileName CLI/ODBC and IBM data server driver configuration keyword
- TxnIsolation CLI/ODBC and IBM data server driver configuration keyword
- UseOldStpCall CLI/ODBC and IBM data server driver configuration keyword