You can use the Loader command USE USER to open a database session with the specified information.
Syntax
<use_user_command> ::= USE USER <user_spec> [SCHEMA <schema_name>] [DB <database_spec>] [<isolation_level_spec>] <user_spec> ::= <database_user> <password> <database_spec> ::= <database_name> [ON <database_computer> [ENCRYPTION <protocol_name>]] <isolation_level_spec> ::= ISOLATION LEVEL <unsigned_integer>
This command terminates the current Loader connection to the database and opens a new database session with the specified parameters. This setting applies as long as no new parameter is specified with a USE command.
The database system automatically converts the name of the database user (database_user) and the password (password) to uppercase letters. If you want to suppress the conversion, you must place the name in quotation marks (Database Administration, Conventions for user names and passwords).
You can specify the schema where the user is to be logged on. If the name of the schema (schema_name) is identical to a keyword or if upper and lowercase notation is relevant, the name must be placed in double quotation marks. If you do not specify a schema, the user uses the assigned schema. This setting applies as long as no other schema is specified using a USE USER, USE SCHEMA or SET CURRENT SCHEMA command.
You can specify the database specification (database_name and other information).
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. |
If you do not specify a database specification in the USE USER command, the new connection is opened to the database that was used prior to the USE USER command or set using option –u. You can open another database session with the USE DB command.
You can specify the isolation level.
unsigned_integer |
Value of the isolation level to be set (default value: 3); see also: SQL Reference Manual, CONNECT Statement (connect_statement), Concepts of the Database System, Isolation Level |
Example
USE USER mona red DB demodb ON genua
Use user MONA to log on to database DEMODB on computer GENUA
Example
USE USER mona red SCHEMA hotel DB demodb ON genua
Use user MONA to log on to database DEMODB in the schema HOTEL on computer GENUA
Example
USE USER mona red DB demodb ON genua ISOLATION LEVEL 0
Set isolation level 0.