Call with the SAP DB Loader CLI (LOADERCLI) (SAP Library

Call with the SAP DB Loader CLI (LOADERCLI)

The Call of the SAP DB Loader can be performed using the SAP DB Loader CLI (LOADERCLI) client.

Call

loadercli [<options>] –b <command_file>

You can specify options when calling the SAP DB Loader. The desired commands and SQL statements must be stored in a command file. When calling the SAP DB Loader, you must specify the command file using the option–b <command_file>.

Process Flow

During the creation of a connection to the database instance, the SAP DB Loader first evaluates the specified options. You must specify at least the name of the database instance (Option –d <database_name>). The commands and SQL statements in the command file are then executed.

Example

loadercli -d demodb -u sqltravel01,travel01 -b command.dat -E 20

The SAP DB Loader creates a connection to the database instance demodb for the user sqltravel01. The Loader processes the commands and statements contained in the command file command.dat. If errors (return code <> 0) occur, the processing of the command file is terminated as soon as 20 error messages occur.

Result

The SAP DB Loader executes the commands and SQL statements specified in the command file. The SAP DB Loader writes a log file

Errors

If an error occurs, the Loader terminates the processing of the commands and SQL statements (either immediately, or after the number of errors specified in option –E has occurred). It is not possible to react to the errors when using the SAP DB Loader CLI.

Note

To enable you to respond to errors, the SAP DB Loader functions are available as a library for the Perl and Python script languages.