Calling the Loader

The Loader database tool consists of a client part and a server part. The Loader client transmits the commands to be processed. The Loader server establishes the connection to the database instance and processes the commands.

See also: Concepts of the Database System, Architecture of the Database Tools

You can install the required Loader software components by specifying the following installation profiles: Loader or All.

See also: Installation Guide, Installation Profiles

Process Flow

The way in which the Loader server is called varies depending on which Loader client you are using.

Call Options of the Loader CLI

Perl Manual, SAP::DBTech::loader Module

Python Manual, sdb.loader Module

Java Manual, Loader Java Classes

Syntax Rules for Calling the Loader

Note the following general syntax rules when you call the Loader.

?     Case-sensitivity
There is no distinction between upper- and lower-case letters. The Loader converts all names to upper-case characters internally, unless you place character strings in double quotation marks.

?     Keywords
Both the keywords of the Loader and the SQL keywords can be used to denote database objects if they are placed in single or double quotation marks.

This documentation contains only a short summary of the functions of the script languages that can be used in the Loader. For more information, see the vendor documentation for Perl, Python, or Java.

See also:

Key Words: Overview

SQL Reference Manual, Keyword (key_word)