Entering content frame

Syntax documentation Opening an SQL Session: -uSQL Locate the document in its SAP Library structure

Use

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.

Note

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

Prerequisites

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.

Syntax

-uSQL [<database_user>,<password>]

or logon with XUSER: -USQL <user_key>

Example

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>

 

Leaving content frame