Entering content frame

Background documentation XUSER Data Locate the document in its SAP Library structure

You can save XUSER data when you use the XUSER tool.

XUSER can manage up to 32 combinations of XUSER data for each operating system user.

        Windows 2000/Windows XP: XUSER data is stored in the database registry.
You are not permitted to make manual changes in the registry because these may result in inconsistencies in the operating system.

        UNIX: XUSER data is stored in the file .XUSER.62 (also referred to as the XUSER file) in the user’s HOME directory.

Procedure

You can generate the XUSER data as followed:

        Use XUSER options

        Generate XUSER data in the background

You can enter the following XUSER data with SAP DB Version 7.4:

XUSER Data

Explanation

user_key

Name of the user key used to address this combination of XUSER data (character string with a maximum of 18 characters)

XUSER data is delivered under the user key name DEFAULT in the program XUSER. This name cannot be changed.
If you enter additional key names, these are case-sensitive.

If you do not specify a user key, then the remaining data refers to the DEFAULT user key.

user_name

User name (character string with a maximum of 18 characters)

If the user name contains small letters or special characters, it must appear within double quotation marks. Otherwise small letters will be converted to capitals.

password

Password of user (character string with a maximum of 18 characters)

If the password contains small letters or special characters, it must appear within double quotation marks. Otherwise small letters will be converted to capitals.

database_name

Name of the database instance that you want to work with (character string with a maximum of 18 characters)

If you do not specify a database, the system uses the name in the environment variable SERVERDB.
This entry is case-sensitive.

database_server

Name of the server on which the database is running (character string with a maximum of 64 characters)

If you do not specify a name, the local server is selected.
This entry is case-sensitive.

SQL_mode

SQL mode (character string with a maximum of eight characters)

If you do not specify a mode, the INTERNAL SQL mode is selected.
Possible values: INTERNAL, SAPDB, ANSI, DB2, ORACLE, SAPR3
This parameter affects the precompiler programs.

timeout

Timeout value in seconds

If you do not specify a value, the value –1 is chosen. This means that the default value of the database instance is used.
Possible values: -1, <number>, 0
If you set the timeout value to 0, then no timeout value is used.

isolation_level

Isolation level (for application programs and precompilers only)

If you do not specify a value, the value –1 is chosen. This means that the default value of the database instance is used.
Possible values: -1, 0, 1, 2, 3, 10, 15, 20, 30

 

 

Leaving content frame