The properties of the DB2Connection class are listed here.
Name | Description |
---|---|
ARMCorrelator | Sets the connection property to allow the
association of statements to a workload manager on the data server. Data server restrictions:
|
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:
|
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. |
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. |