User Guide

SAP AG November 2002
SAP DB E-Catalog
SAP DB E-Catalog is a database instance type [Page 132] of the SAP DB database system.
In Internet catalog applications, a small number of hits must be determined from a large
number of product descriptions. To support this, the TREX search engine has been integrated
in the SAP DB OLTP [Page
149] relational database system. With the TREX search engine,
product descriptions (long texts) can be indexed, and the search terms looked for (exact
search, phrase search, fuzzy search, linguistic search).
One application example is the BugsEye or eMerge product from Requisite.
SAP DB Loader
The SAP DB Loader is a database tool [Page 136] for loading and unloading data.
In addition to processing Loader commands [Page 64], the SAP DB Loader can also execute
all SQL statements [See SAP DB Library]
.
See also:
SAP DB Loader: SAP DB 7.4 [See SAP DB Library]
Architecture
The SAP DB Loader consists of a server part and a client part.
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]
User Manual: SAP DB 148