User Guide

SAP AG November 2002
Server/Client for the SAP DB Loader
Server Client
Loader
[Page 59]
LOADERCLI
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 [Page 55]
Calling with LOADERCLI
loadercli [<options>] –b <command_file>
When you call the SAP DB Loader with the LOADERCLI [See SAP DB Library]
, you can
specify options [Page
64], commands, and SQL statements. The commands and SQL
statements must be stored in a command file [See SAP DB Library]
(<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 [Page
132], 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 [See SAP DB Library]
Calling with Loader Python Script [See SAP DB Library]
Options (LOADERCLI)
When you call the SAP DB Loader [Page 148] with the SAP DB Loader CLI (LOADERCLI),
you can transfer a number of options to the SAP DB Loader. For a list of all possible options,
see SAP DB Loader: SAP DB 7.4, Section Options [See SAP DB Library]
.
For a link to be established with the database instance on the local computer, you must enter
at least option -d <database_name>. In addition, the name of a command file [See SAP
DB Library] must be specified in option -b <command_file>.
The following user data as options [Page
31] should be transferred: database
user [Page 136] and the name of the database instance [Page 132]
loadercli -u samplename,secret -d TST -b command.dat
The Loader is called and a database session is created for the database user
samplename, password secret, with the database instance TST. All further
commands statements can be found in command file command.dat.
Loader Commands
A series of commands and SQL statements [See SAP DB Library] can be transferred to the
SAP DB Loader [Page 148]. For a list of all possible commands, see SAP DB Loader: SAP
DB 7.4, Section Commands [See SAP DB Library].
User Manual: SAP DB 64