Entering content frame

Component documentation Loader Tutorial Locate the document in the library structure

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 Structure linkDownload section and the Structure linkInstallation Manual.

For more information about the database system, see Structure linkConcepts of the Database System. For quick access to all documentation and an explanation of the most important terms, use the alphabetical Structure linkGlossary.

You will find a detailed description of the Loader commands in the Structure linkLoader 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

Note

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 Structure linkidentifiers for the database objects and entering values in the form of Structure linkliterals.

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, Structure linkDemo Database, Structure linkObjects in the HOTEL Schema

 

Leaving content frame