Background documentationUSE USER Command Locate this document in the navigation structure

 

You can use the Loader command USE USER to open a database session with the specified information.

Structure

Syntax Syntax

  1. <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>
End of the code.

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_spec>

    database_name

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

    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.

    ISOLATION LEVEL <unsigned_integer>

    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

Example Example

USE USER mona red DB demodb ON genua

End of the example.

Use user MONA to log on to database DEMODB on computer GENUA

Example Example

USE USER mona red SCHEMA hotel DB demodb ON genua

End of the example.

Use user MONA to log on to database DEMODB in the schema HOTEL on computer GENUA

Example Example

USE USER mona red DB demodb ON genua ISOLATION LEVEL 0

End of the example.

Set isolation level 0.