This Loader tutorial is designed to introduce you to the Loader commands for exporting and importing, and to illustrate them with examples.
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.
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: