Loader Tutorial

Purpose

This Loader tutorial is designed to introduce you to the Loader commands for exporting and importing, and to illustrate them with examples.

Implementation

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.

Features

Demo Databases

To work through the examples in this Loader tutorial, you need the Demo Databases DEMODB and TESTDB.

Examples of Commands

The Loader commands that are described in the examples in this tutorial can be grouped in the following areas:

?     Exporting

?     Importing

?     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.

Operating Modes

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:

?     Transport Mode

?     Command File Mode

?     Session Mode

See also:

Concepts of the Database System, Demo Database, Objects in the HOTEL Schema