Option in the Database Manager CLI.
If you specify this option, the DBM command to open an SQL session is executed implicitly. You transfer the user name and the password of the desired database user. The SQL session is established with its user data.
Certain DBM commands require an SQL session before they can be executed.
If no operator is specified with this option, the Database Manager CLI uses the data of the current DBM operator.
User details can be stored for various tasks with the help of the program XUSER and used for logging on.
Note the
different meanings of the command with uppercase and lowercase
specification.
-uSQL: Explicit specification of the user
identified with <database_user> and <password>
-USQL: Logon with a user stored in the XUSER
file.
See also: Using XUSER
You are also using the option -d at the same time to specify a database instance and the option -u to log on to the Database Manager.
-uSQL [<database_user>,<password>]
or logon with XUSER: -USQL <user_key>
Display the content of the database table users of the database instance myDB using the database user SAPR3:
dbmcli –d myDB –u DBM,DBM –uSQL SAPR3,SAP sql_execute SELECT * FROM users
OK
<content_of_table_users>