Background documentationUSE DB Command Locate this document in the navigation structure


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


Syntax Syntax

  1. <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.



Name of the database

This name ist 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).


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.


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

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.