Entering content frame

Background documentation Options Locate the document in its SAP Library structure

When calling the Loader using the Loader CLI (LOADERCLI), you can specify options:

loadercli [<options>]

<options>

-b <command_file>

Name of the command file, specify the operating mode

-d <database_name>

Name of the database instance

-u <user_name>,<password>

User name and password

-n <database_server>

Database server

-r <loader_server>

Name of the local Loader server, if you want to call the Loader CLI and Loader Server separately

-I <isolation_level>

Isolation level

-E <number>

Maximum permitted number of errors

-o[w|a] <file_name>

Name of the output file

-p <number><substitution_string>

Specifies a substitution parameter

-cs <command_separator>

Specifies a command separator

-R <directory_name>

Directory that contains the programs that depend on the version of the database software

-cs

Defines the command separator for the command file and the interactive mode of the Loader CLI (the default value is a double slash (//) in background mode and ENTER in interactive mode)

-V

Version of the Loader

-v

Version of the LoaderCLI

-h

Help

Use

When you call the Loader, you usually specify the name of the user (option -u) and the database instance (option -d). This creates a connection to the specified database instance for this user.

You can specify all the required commands and SQL statements in a command file (option -b), or you can enter the interactively.

Example

loadercli -d hoteldb -u mona,red -b command.dat

You can also call the Loader without options, or by specifying only a database instance name (option -d). In this case, you must transfer all other commands for creating a database session in the command file. This creates the connection between the Loader and this or another database instance.

 

Leaving content frame