DB2 10.5 for Linux, UNIX, and Windows
DB2 10.5 for Linux, UNIX, and Windows
Changes the current database associated with an open DB2Connection.
[Visual Basic]
NotOverridable Public Sub ChangeDatabase( _
ByVal value As String _
) Implements IDbConnection.ChangeDatabase
[C#]
public void ChangeDatabase(
string value
);
[C++]
public: __sealed void ChangeDatabase(
String* value
);
[JScript]
public function ChangeDatabase(
value : String
);| Exception type | Condition |
|---|---|
| ArgumentException | The database name is not valid. |
| InvalidOperationException | The connection is not open. |
| DB2®Exception | Cannot change the database. |
The value parameter must contain a valid database name, and cannot contain a null value, an empty string (""), or a string with only blank characters.
[Visual Basic, C#] The following example creates a DB2Connection and changes the current database.
[Visual Basic]
Public Sub CreateDB2Connection()
Dim myConnString As String = _
"DATABASE=SAMPLE"
Dim myConnection As New DB2Connection(myConnString)
myConnection.Open()
myConnection.ChangeDatabase("SAMPLE2")
MessageBox.Show("Database: " + myConnection.Database.ToString())
myConnection.Close()[C#]
public void CreateDB2Connection()
{
string myConnString = "DATABASE=SAMPLE";
DB2Connection myConnection = new DB2Connection(myConnString);
myConnection.Open();
myConnection.ChangeDatabase("SAMPLE2");
MessageBox.Show("Database: " + myConnection.Database.ToString());
myConnection.Close();
}