Entering content frame

Background documentation Uploading and Loading: Commands Locate the document in its SAP Library structure

The Loader can process a range of commands and SQL statements, including Loader-specific commands for loading and unloading data.

The language scope of the Loader allows you to load or unload, in increasing granularity, a complete database, the objects of a user, individual tables, or a set of columns of a table.

What do you want to unload or load?

Loader Commands

Database catalog and application data

DBEXTRACT/DBLOAD
You can use external backup tools to unload or load the data.

Database catalog

CATALOGEXTRACT ALL/CATALOGLOAD ALL
You can use external backup tools to unload or load the data.

Database catalog objects and the application data of a user

CATALOGEXTRACT USER/CATALOGLOAD USER
TABLEEXTRACT USER/TABLELOAD USER

Tables

CATALOGEXTRACT TABLE/CATALOGLOAD TABLE
TABLEXTRACT TABLE/TABLELOAD TABLE
DATAEXTRACT/DATALOAD

Set of qualified columns of a table

DATAEXTRACT/DATALOAD
FASTLOAD
DATAUPDATE

See also:

Unloading and Loading: Syntax Elements

Unloading and Loading LONG Values

Unloading and Loading with External Backup Tools

Syntax Rules: Overview

 

Leaving content frame