This Loader tutorial is designed to introduce you to the Loader commands for exporting and importing, and to illustrate them with examples.
For information on
where to obtain MaxDB software and how to install it, see the Download section
and the
Installation
Manual.
For more information about the database
system, see Concepts of the
Database System. For quick access to all documentation and an explanation
of the most important terms, use the alphabetical
Glossary.
You will find a detailed description of
the Loader commands in the Loader
documentation.
To work through the examples in this Loader tutorial, you need the Demo Databases DEMODB and TESTDB.
The Loader commands that are described in the examples in this tutorial can be grouped in the following areas:
● UPDATE COLUMNS Command for updating column values
To make commands more readable, the keywords are written in upper-case letters and the commands statements are structured. Upper and lower-case spellings of syntax elements and blank characters or line breaks are not relevant for executing Loader commands.
Upper and lower-case letters,
however, may be important when choosing identifiers for
the database objects and entering values in the form of
literals.
The input to the Loader can happen via three operating modes: interactive transport mode, command file mode and session mode.
The use of the three operating modes can be explained using examples:
See also:
Concepts of the Database System, Demo Database,
Objects in the
HOTEL Schema