InterSystems SQL Reference
Sets the current namespace and database.
||The namespace and corresponding database to be used by the current process as the current namespace.
The USE DATABASE command switches the current process to the specified namespace and its associated database. This allows you to change namespaces within SQL. The DATABASE keyword is optional.
The specified dbname
is the name of the desired namespace and corresponding directory that contains the database files. Specify dbname
as an identifier
. Namespace names are not case-sensitive. For further information on using namespaces, see Namespaces and Databases
in the Orientation Guide for Server-Side Programming
USER>>USE DATABASE Samples
SAMPLES>>USE DATABASE "User"
If the specified dbname does not exist, InterSystems IRIS issues an SQLCODE -400 error.
The USE DATABASE command is a privileged operation. Prior to using USE DATABASE, it is necessary to be logged in as a user with appropriate privileges. Failing to do so results in an SQLCODE -99 error (Privilege Violation).
You must have the %Service_Login:Use privilege to invoke the $SYSTEM.Security.Login
method. For further information, refer to %SYSTEM.Security
in the InterSystems Class Reference
You can also switch to a different namespace using the ObjectScript ZNSPACE
command, or the SET $NAMESPACE
Executing via xDBC
When the USE DATABASE command is executed via xDBC, the server process performs a simulated connection reset. Data structures used by the server process are cleaned up. However, commit mode is not changed. The Read Committed setting is not changed either. If a transaction is in process, the transaction simply continues and is not committed or rolled back.
Content Date/Time: 2019-09-20 05:47:55