DB2Connection properties

The properties of the DB2Connection class are listed here.

Public properties

Name	Description
ARMCorrelator	Sets the connection property to allow the association of statements to a workload manager on the data server. Data server restrictions: Informix® This property has no effect.
BatchCommandTimeout	Gets or sets the wait time in seconds before a command that consists of chained SQL statements is terminated.
CacheData	Gets or sets a Boolean value that indicates whether data caching is being used.
CacheUSRLIBLValue	Gets or sets a Boolean value that indicates whether caching of the user libraries (*USRLIBL libraries) is enabled for all connections to DB2 for i in the same connection pool.
Chaining	Gets a Boolean value that indicates whether chaining is active.
ClientAccountingInformation	Gets or sets the string that contains the client accounting information.
ClientApplicationInformation	Gets or sets the string that contains the client application name.
ClientCorrelationToken	Gets or sets the client correlation token name on DB2 for z/OS Version 11 servers in new function mode (NFM).
ClientUser	Gets or sets the string that contains the client user ID.
ClientWorkstation	Gets or sets the string that contains the name of the client workstation.
ConnectionString	Gets or sets the string that is used to open a database connection.
ConnectionTimeout	Gets or sets a value that limits the amount of time that an application waits for a connection.
Container (inherited from the Component class)	Gets the IContainer interface object that contains the Component class object.
Database	Gets the name of the current database or the database that is used after a connection is opened.
DataSource	Gets the name of the current data source or the data source that is used after a connection is opened.
EnableExtendedIndicators	Enables the use of default and unassigned indicators as parameters.
FitHighPrecisionType	Gets or sets the type of precision to use. The acceptable values are as follows: AsString Converts the data type in the column to a .NET string type. ReturnException Results in a truncation exception if the size of the value exceeds the size of the .NET system type. WithTruncate Returns a .NET system type after silently truncating the column value if needed.
ResultSetAsReturnValue	Gets or sets the value that indicates whether the provider retrieves results sets from Informix database server UDRs as a ReturnValue parameter.
RetryParameterBindingOnError	Gets or sets the value that indicates whether the provider reruns failed statements.
ServerBuildVersion	Gets a string that contains the build version of the server to which the client is connected.
ServerMajorVersion	Gets a string that contains the major version of the server to which the client is connected.
ServerMinorVersion	Gets a string that contains the minor version of the server to which the client is connected.
ServerRevisionVersion	Gets a string that contains the revision version of the server to which the client is connected.
ServerType	Gets a string that contains the type of server to which the client is connected.
ServerVersion	Gets a string that contains the version of the server to which the client is connected.
Site (inherited from the Component class)	Gets or sets the ISite interface object of the Component class object.
State	Gets the current state of the connection.
SystemNaming	Specifies whether the system naming mode or the SQL naming mode is used for a connection to the DB2 for i server.

Protected properties

Property	Description
DesignMode (inherited from the Component class)	Gets a value that indicates whether the Component class object is in design mode.
Events (inherited from the Component class)	Gets the list of event handlers that are attached to a Component class object.