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 configuration keyword
- DeferredPrepare CLI/ODBC configuration keyword
- DescribeCall CLI/ODBC configuration keyword
- DescribeParam CLI/ODBC configuration keyword
- DisableKeysetCursor CLI/ODBC configuration keyword
- DisableMultiThread CLI/ODBC configuration keyword
- DisableUnicode CLI/ODBC configuration keyword
- EnableNamedParameterSupport CLI/ODBC configuration keyword
- OleDbReportIsLongForLongTypes CLI/ODBC configuration keyword
- OleDbSQLColumnsSortByOrdinal CLI/ODBC configuration keyword
- RetCatalogAsCurrServer CLI/ODBC configuration keyword
- RetOleDbConnStr CLI/ODBC configuration keyword
- Trusted_Connection CLI/ODBC configuration keyword (use
SQLDriverConnect()
to set this keyword) - TimestampTruncErrToWarning CLI/ODBC configuration 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 configuration keyword
- CurrentImplicitXMLParseOption CLI/ODBC configuration keyword
- DateTimeStringFormat CLI/ODBC configuration keyword
- DecimalFloatRoundingMode CLI/ODBC configuration keyword
- FloatPrecRadix CLI/ODBC configuration keyword
- Graphic CLI/ODBC configuration keyword
- LOBMaxColumnSize CLI/ODBC configuration keyword
- LongDataCompat CLI/ODBC configuration keyword
- MapBigintCDefault CLI/ODBC configuration keyword
- MapCharToWChar CLI/ODBC configuration keyword
- MapDateCDefault CLI/ODBC configuration keyword
- MapDateDescribe CLI/ODBC configuration keyword
- MapDecimalFloatDescribe CLI/ODBC configuration keyword
- MapGraphicDescribe CLI/ODBC configuration keyword
- MapTimeCDefault CLI/ODBC configuration keyword
- MapTimeDescribe CLI/ODBC configuration keyword
- MapTimestampCDefault CLI/ODBC configuration keyword
- MapTimestampDescribe CLI/ODBC configuration keyword
- MapXMLCDefault CLI/ODBC configuration keyword
- MapXMLDescribe CLI/ODBC configuration keyword
- OleDbReturnCharAsWChar CLI/ODBC configuration keyword
- PromoteLONGVARtoLOB CLI/ODBC configuration keyword
- XMLDeclaration CLI/ODBC configuration keyword
Enterprise configuration keywords
Use
the enterprise configuration keywords to maximize the efficiency of
connections to large databases.
- CLIPkg CLI/ODBC configuration keyword
- ConnectNode CLI/ODBC 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 configuration keyword
- ExtendedTableInfo CLI/ODBC configuration keyword
- GranteeList CLI/ODBC configuration keyword
- GrantorList CLI/ODBC configuration keyword
- OnlyUseBigPackages CLI/ODBC configuration keyword
- ReportPublicPrivileges CLI/ODBC configuration keyword
- ReturnSynonymSchema CLI/ODBC configuration keyword
- SchemaList CLI/ODBC configuration keyword
- ServerMsgMask CLI/ODBC configuration keyword
- ServerMsgTextSP CLI/ODBC configuration keyword
- SQLCODEMAP CLI/ODBC configuration keyword
- SysSchema CLI/ODBC Configuration Keyword
- TableType CLI/ODBC configuration keyword
- UseServerMsgSP CLI/ODBC 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.
- ConnectTimeout CLI/ODBC configuration keyword
- CurrentFunctionPath CLI/ODBC configuration keyword
- Interrupt CLI/ODBC 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 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 configuration keyword
- AltPort CLI/ODBC configuration keyword
- Attach CLI/ODBC configuration keyword
- Authentication CLI/ODBC configuration keyword
- BIDI CLI/ODBC 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 configuration keyword
- KRBPlugin CLI/ODBC configuration keyword
- Port CLI/ODBC configuration keyword
- Protocol CLI/ODBC configuration keyword
- PWDPlugin CLI/ODBC configuration keyword
- ServiceName CLI/ODBC configuration keyword
- Security CLI/ODBC 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 configuration keyword
- AppUsesLOBLocator CLI/ODBC configuration keyword
- BlockForNRows CLI/ODBC configuration keyword
- CacheUsrLibL CLI/ODBC configuration keyword
- BlockLobs CLI/ODBC configuration keyword
- ClientBuffersUnboundLOBS CLI/ODBC configuration keyword
- ColumnwiseMRI CLI/ODBC configuration keyword
- ConcurrentAccessResolution CLI/ODBC configuration keyword
- CurrentMaintainedTableTypesForOpt CLI/ODBC configuration keyword
- CURRENTOPTIMIZATIONPROFILE CLI/ODBC configuration keyword
- DB2Degree CLI/ODBC configuration keyword
- DB2Explain CLI/ODBC configuration keyword
- DB2NETNamedParam CLI/ODBC configuration keyword
- DB2Optimization CLI/ODBC configuration keyword
- DescribeInputOnPrepare CLI/ODBC configuration keyword
- DescribeOutputLevel CLI/ODBC configuration keyword
- FET_BUF_SIZE CLI/ODBC configuration keyword
- GetDataLobNoTotal CLI/ODBC configuration keyword
- KeepDynamic CLI/ODBC configuration keyword
- LOBCacheSize CLI/ODBC configuration keyword
- LOBFileThreshold CLI/ODBC configuration keyword
- LockTimeout CLI/ODBC configuration keyword
- MaxLOBBlockSize CLI/ODBC configuration keyword
- OptimizeForNRows CLI/ODBC configuration keyword
- Reopt CLI/ODBC configuration keyword
- RetryOnMERGE CLI/ODBC configuration keyword
- ReturnAliases CLI/ODBC configuration keyword
- SkipTrace CLI/ODBC configuration keyword
- StmtConcentrator CLI/ODBC configuration keyword
- StreamGetData CLI/ODBC configuration keyword
- StreamOutputLOBonCall CLI/ODBC configuration keyword
- StreamPutData CLI/ODBC configuration keyword
- Underscore CLI/ODBC 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 configuration keyword
- AppendRowColToErrorMessage CLI/ODBC configuration keyword
- DiagLevel CLI/ODBC configuration keyword
- DiagPath CLI/ODBC configuration keyword
- IgnoreWarnings CLI/ODBC configuration keyword
- IgnoreWarnList CLI/ODBC configuration keyword
- LoadXAInterceptor CLI/ODBC configuration keyword
- NotifyLevel CLI/ODBC configuration keyword
- Patch1 CLI/ODBC configuration keyword
- Patch2 CLI/ODBC configuration keyword
- ReportRetryErrorsAsWarnings CLI/ODBC configuration keyword
- RetryParameterBindingOnError CLI/ODBC configuration keyword
- RetryOnError CLI/ODBC 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 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 configuration keyword
- ClientAcctStr CLI/ODBC configuration keyword
- ClientApplName CLI/ODBC configuration keyword
- ClientCorrelationToken CLI/ODBC configuration keyword
- ClientUserID CLI/ODBC configuration keyword
- ClientWrkStnName CLI/ODBC configuration keyword
- CommitOnEOF CLI/ODBC configuration keyword
- ConnectType CLI/ODBC configuration keyword
- CursorHold CLI/ODBC configuration keyword
- Mode CLI/ODBC configuration keyword
- SQLOverrideFileName CLI/ODBC configuration keyword
- TxnIsolation CLI/ODBC configuration keyword
- UseOldStpCall CLI/ODBC configuration keyword