Function documentationOpening a Database Session: Loader CLI Options Locate this document in the navigation structure

 

You can specify Loader CLI options to open a database session in Command File Mode or Session Mode.

connect_options

-d <database_name>

Name of database

-u [<database_user>[,<password>]]

Name and password of database user

-n <database_computer>[:<port>]

Name of database computer

-s <schema_name>

Name of schema

-e <encryption>

Encryption method
-d <database_name>

Loader establishes a connection to the specified database database_name. When it does this, Loader implicitly executes the Loader command USE DB, or Loader command USE USER, if both database name and database user name and password have been specified.

Note Note

You can also specify the name of the database with the Loader commands USE DB or USE USER. This enables you to change the database name during the Loader session.

End of the note.
-u [<database_user>[,<password>]]

The prerequisite for using this option is that you use option -d for specifying a database at the same time. If you use option -u without specifying the database user name and password <database_user>,<password>, Loader prompts you for a database user name/password combination. In this way you can avoid the database user password being visible in the command line, command history, and the operating system process list. A database session is created for the specified database user. At the same time, Loader executes the Loader command USE USER implicitly. The database user name and password are automatically converted into uppercase letters by the database system.

Note Note

You can also use command USE USER to specify user data. This enables you to switch database users during a Loader session.

End of the note.
-n <database_computer>[:<port>]

The prerequisite for using this option is that you use option –d or options –d and –u at the same time. Loader opens a database session on the specified computer database_computer. When it does this, the loader implicitly executes the Loader command USE DB, or the Loader command USE USER if both database name and user data have been specified.

Note Note

You can also use command USE DB or USE USER to specify the name of the database computer.

End of the note.
-s <schema_name>

The prerequisite for using this option is that you use options –d and –u at the same time. Loader opens a database session to the specified schema.

Note Note

You can also transfer the name of the schema using the commands USE SCHEMA, USE USER or SET CURRENT_SCHEMA.

End of the note.
-e <encryption>

You can only use this option if your SAP system is configured for the encryption. You can switch on the encryption function and select the encryption method for communication.

Example

Loader Tutorial, Command File Mode, Session Mode

More Information

Opening a Session: Loader CLI Options

Opening a Session: Loader Commands

Database Administration, Encryption