SAP DB Loader 

The SAP DB Loader is a database tool for loading and unloading data. In addition to processing Loader commands, the SAP DB Loader can also execute all SQL statements (see SAP DB Loader: SAP DB 7.4).

Architecture

The SAP DB Loader consists of a server part and a client part.

Server	Client
Loader	SAP DB Loader CLI A script interface (for example to Perl and Python) is available

If you want to react to SAP DB Loader return codes, you must use the script interface.

See also: Architecture of the SAP DB Loader

 

Call with SAP DB Loader CLI

loadercli [<options>] –b <command_file>

When you call the SAP DB Loader with the CLI, you can specify options, commands, and SQL statements. The commands and SQL statements must be stored in a command file (<command_file>), which you specify using option -b <command_file>.

For a link to be established with a database instance on the local computer, you must enter at least the name of the database instance (option -d <database_name>) when calling the Loader.

When creating the connection between the Loader and the database instance, the Loader first uses the specified options. The commands and SQL statements of the command file are then processed in the specified sequence.

See also: Calling with Loader Perl Script, Calling with Loader Python Script