USE REPOSITORY command

The USE REPOSITORY command establishes a connection to the specified repository.

As a result of running this command, the following actions occur:

All opened objects (including procedures) are closed
The current repository connection is stopped
A new connection to specified repository is established

You can omit the USER/PASSWORD of the repository if it is not secured. You can omit the DBUSER/DBPASSWORD if they are specified (and remembered) for the specified repository connection.

Syntax

>>-- USE REPOSITORY ----- RepositoryName -------------------<<
                              (+- USER = ... --------------+
                               +- PASSWORD = ... ----------+
                               +- DBUSER = ... ------------+
                               +- DBPASSWORD = ... --------+

Parameters

RepositoryName: The name of repository to connect to. If the name includes spaces, enclose it quotes.
USER: The user name used to connect to the secured repository.
Note: This parameter is required only if the repository is secured.
PASSWORD: The password used to connect to the secured repository.
Note: This parameter is required only if the repository is secured.
DBUSER: The user name used to connect to the specified repository's database.
If you checked Remember user name and password in the Repository Connection preferences, you can omit specifying the value here.
Note: The parameter value entered here overrides the value set in the Repository Connection preferences.
DBPASSWORD: The password used to connect to the specified repository's database.
If you checked Remember user name and password in the Repository Connection preferences, you can omit specifying the value here.
Note: The parameter value entered here overrides the value set in the Repository Connection preferences.

Example

USE REPOSITORY Default
USE REPOSITORY SomeRepository (USER=User PASSWORD=password