DB2 Version 9.7 for Linux, UNIX, and Windows

DB2Connection.ChangeDatabase Method

Changes the current database associated with an open DB2Connection.

Namespace:: IBM.Data.DB2
Assembly:: IBM.Data.DB2 (in IBM.Data.DB2.dll)

Syntax

[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
);

Implements:: IDbConnection.ChangeDatabase

Parameters

value: The database name.

Exceptions

Exception type	Condition
ArgumentException	The database name is not valid.
InvalidOperationException	The connection is not open.
DB2Exception	Cannot change the database.

Remarks

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.

Example

[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();
 }