The following tables list the members exposed by the DB2Connection class.
Name | Description |
---|---|
DB2®Connection | Overloaded. Initializes a new instance of the DB2Connection class. |
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. |
Name | Description |
---|---|
BeginChain | Marks the beginning of a chain of insert, update, and delete statements to be sent to the database server. |
BeginTransaction | Overloaded. Begins a transaction at the database. |
ChangeDatabase | Changes the current database associated with an open DB2Connection. |
Close | Closes the connection to the database. This is the preferred method of closing any open connection. |
CreateCommand | Creates and returns a DB2Command object associated with the DB2Connection. |
CreateObjRef (inherited from MarshalByRefObject) | Creates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object. |
Dispose (inherited from Component) | Overloaded. Releases the resources used by the Component. |
DropDTD | Drops the DTD registered with the database. |
DropXmlSchema | Drops the schema registered with the database. Data server restrictions:
|
EndChain | Marks the end of a chain of insert, update, and delete statements to be sent to the database server. |
EnlistDistributedTransaction | Enlists in the specified transaction as a distributed transaction. |
EnlistTransaction (inherited from DbConnection) | Overloaded. Enlists in the specified transaction. |
Equals (inherited from Object) | Overloaded. Determines whether two Object instances are equal. |
GetDTD | Gets the DTD registered with the database. |
GetHashCode (inherited from Object) | Serves as a hash function for a particular type, suitable for use in hashing algorithms and data structures like a hash table. |
GetLifetimeService (inherited from MarshalByRefObject) | Retrieves the current lifetime service object that controls the lifetime policy for this instance. |
GetType (inherited from Object) | Gets the Type of the current instance. |
GetSchema() | Overloaded. Returns a DataTable with metadata for the data source associated with this DB2Connection instance. |
GetXmlSchemaSet | Gets the schema registered with the database. Data server restrictions:
|
InitializeLifetimeService (inherited from MarshalByRefObject) | Obtains a lifetime service object to control the lifetime policy for this instance. |
Open | Opens a connection to a database with the property settings specified by the ConnectionString . |
RegisterDTD | Registers the DTD with the database. |
RegisterXmlSchema | Overloaded. Registers the schema with the
database, including the URLs for the files containing the XML document
property data, and a URL for the file containing the XML schema properties
document. Data server restrictions:
|
ReleaseObjectPool | Indicates that the DB2Connection object pool can be released when the last underlying connection is released. |
ToString (inherited from Object) | Returns a String that represents the current Object. |
Name | Description |
---|---|
Disposed (inherited from Component) | Adds an event handler to listen to the Disposed event on the component. |
InfoMessage | Occurs when the IBM Data Server Provider for .NET sends a warning or an informational message. |
StateChange | Occurs when the state of the connection changes. |
Name | Description |
---|---|
DesignMode (inherited from Component) | Gets a value that indicates whether the Component is currently in design mode. |
Events (inherited from Component) | Gets the list of event handlers that are attached to this Component. |
Name | Description |
---|---|
Dispose | Overloaded. Overridden. Releases the resources used by the DB2Connection. |
Finalize (inherited from Object) | Overridden. Allows an Object to attempt to free resources and perform other cleanup operations
before the Object is reclaimed by garbage collection. In C# and Microsoft Visual C++, finalizers are expressed using destructor syntax. |
GetService (inherited from Component) | Returns an object that represents a service provided by the Component or by its Container. |
MemberwiseClone (inherited from Object) | Creates a shallow copy of the current Object. |