USE DB Command

You can use the Loader command USE DB to open another database session.

Structure

Syntax Syntax

<use_database_command> ::=
  USE DB <database_spec>

<database_spec> ::=
  <database_name> [ON <database_computer> [ENCRYPTION <protocol_name>]

End of the code.

With the USE DB command, you switch to another database session without having to exit the Loader session. The connection to the current database is terminated and the new database session is opened.

<database_specification>
`database_name`	Name of the database;, valid for the entire Loader session with this database session If the name of the database is identical to a keyword or if upper and lowercase notation is relevant, the name must be placed in quotation marks (Database Administration, Conventions for Database Names)
`database computer`	Name of the computer on which the database is installed for which a session is to be started. If this is not specified, Loader assumes that the specified database was created on the computer to which the user of Loader is logged on.
`protocol_name`	Name of the encryption protocol After key word `ENCRYPTION`, you can also specify the name of the requested encryption protocol `protocol_name` to ensure that the data transfer is encrypted. This option is currently only supported for SAP systems and SSL.

A database user with the same name and password must exist on the new database. Loader refers all subsequent Loader commands and SQL statements to this new database. This setting applies as long as no other database is specified with a USE DB command.

Example

Example Example

USE USER mona red DB demodb ON genua

//

USE DB demodb ON parma

End of the example.

User MONA is logged on to database DEMODB on computer GENUA. You use the USE DB command to switch to database DEMODB on computer PARMA.

More Information

Opening a Session: Loader Commands

Opening a Database Session: Loader CLI Options