DB2®Connection properties

The properties of the DB2Connection class are listed here.

Public properties

Name Description
public property 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.
public property BatchCommandTimeout Gets or sets the wait time in seconds before a command that consists of chained SQL statements is terminated.
public property CacheData Gets or sets a Boolean value that indicates whether data caching is being used.
public property 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 IBM i in the same connection pool.
public property Chaining Gets a Boolean value that indicates whether chaining is active.
public property ClientAccountingInformation Gets or sets the string that contains the client accounting information.
public property ClientApplicationInformation Gets or sets the string that contains the client application name.
public property ClientCorrelationToken Gets or sets the client correlation token name on Db2 for z/OS Version 11 servers in new function mode (NFM).
public property ClientUser Gets or sets the string that contains the client user ID.
public property ClientWorkstation Gets or sets the string that contains the name of the client workstation.
public property ConnectionString Gets or sets the string that is used to open a database connection.
public property ConnectionTimeout Gets or sets a value that limits the amount of time that an application waits for a connection.
public property Container (inherited from the Component class) Gets the IContainer interface object that contains the Component class object.
public property Database Gets the name of the current database or the database that is used after a connection is opened.
public property DataSource Gets the name of the current data source or the data source that is used after a connection is opened.
public property EnableExtendedIndicators Enables the use of default and unassigned indicators as parameters.
public property 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.
public property ResultSetAsReturnValue Gets or sets the value that indicates whether the provider retrieves results sets from Informix database server UDRs as a ReturnValue parameter.
public property RetryParameterBindingOnError Gets or sets the value that indicates whether the provider reruns failed statements.
public property ServerBuildVersion Gets a string that contains the build version of the server to which the client is connected.
public property ServerFunctionalLevel Gets a string that contains the functional level of the Db2 for z/OS or LUW server to which the client is connected.
public property ServerMajorVersion Gets a string that contains the major version of the server to which the client is connected.
public property ServerMinorVersion Gets a string that contains the minor version of the server to which the client is connected.
public property ServerRevisionVersion Gets a string that contains the revision version of the server to which the client is connected.
public property ServerType Gets a string that contains the type of server to which the client is connected.
public property ServerVersion Gets a string that contains the version of the server to which the client is connected.
public property Site (inherited from the Component class) Gets or sets the ISite interface object of the Component class object.
public property State Gets the current state of the connection.
public property SystemNaming Specifies whether the system naming mode or the SQL naming mode is used for a connection to the Db2 for IBM i server.

Protected properties

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