setdbtype Command

setdbtype command for switching database is mentioned below

DB2:

setdbtype db2 DB2_HOME dbName dbAdminID dbAdminPassword dbUserID dbUserPassword [dbHost dbServerPort dbNode] [createdb]

Oracle :


setdbtype oracle ORACLE_HOME dbName dbAdminID dbAdminPassword dbUserID dbUserPassword [dbHost dbServerPort] [createdb]

Derby/Cloudscape:

setdbtype cloudscape [createdb]

Where:

DB2_HOME

The root directory of DB2. For example, C:\IBM\SQLLIB

ORACLE_HOME

The root directory of the Oracle DBMS. For example, C:\oracle\product\11.1.0\client_1

dbName

The name of the database. For example, mall.

dbAdminID

The database administrator's ID. For example, db2admin or oracle.

dbAdminPassword

The associated password for dbAdminID

dbUserID

The database user ID that connects to the database.

dbUserPassword

The associated password for dbUserID

dbHost

The host name of a remote database server.

dbServerPort

The port number of the remote database server.

dbNode

The node name of the remote database.

createdb

If specified, the command creates a new empty database.