SAP Library - Loader: SAP DB 7.4

Loader: SAP DB 7.4

SAP DB Loader: Overview

SAP DB Loader: Commands and SQL Statements

Commands for Creating a Database Session

Commands for Loading and Unloading

Examples of DATALOAD Commands

SAP DB Loader: Call

Call with the SAP DB Loader CLI (LOADERCLI)

Options

Command File: -b

Database Instance: -d

User Data: -u

Database Server: -n

Loader Server: -r

Maximum Permitted Number of Errors: -E

Output File: - o[w|a]

Substitution Parameter: -p

InstRoot Directory: -R

Loader Version: -V

LOADERCLI Version: -v

Help: -h

Command File

Syntax Rules for Commands Files

Call with the Perl Interface of the SAP DB Loader

Perl Classes

Perl: Loader Class

Perl: Exception Classes

Perl: Example 1

Perl: Example 2

Perl: Example 3

Perl: Example 4

Perl: Example 5

Call with the Python Interface of the SAP DB Loader

Python Classes

Python: Loader Class

Python: Exception Classes

Python: Example 1

Python: Example 2

Python: Example 3

Python: Example 4

Python: Example 5

Call with the Java Interface of the SAP DB Loader

Java Classes

Java: Loader Class

Java: Exception Classes

Syntax Rules for Calling the SAP DB Loader

SAP DB Loader: Log Functions

Log File

TRANSFORMATIONMODEL

TRANSFORMATIONMONITOR

TRANSFORMATIONPACKAGES

TRANSFORMATIONRESOURCES

TRANSFORMATIONSTATISTICS

TRANSFORMATIONSTEPS

AUTOCOMMIT Command

CATALOGEXTRACT Command

CATALOGLOAD Command

DATAEXTRACT Command

DATALOAD Command

DATAUPDATE Command

DBEXTRACT Command

FASTLOAD Command

SET Command

SQLMODE Command

TABLEEXTRACT Command

TABLELOAD Command

USE SERVERDB Command

USE USER Command

Syntax Rules for Commands

Syntax Rules for Setting up a Session

Syntax Rules for Table Descriptions

Syntax Rules for Column Descriptions

Syntax Rules for Describing the Data Stream

acc_column_spec

acc_column_spec_mlt

bool_spec

cataloginstream_spec

catalogoutstream_spec

code_page_spec

code_spec

column_assignment

column_descriptor

column_id

column_id_spec

column_names

compare_operator

condition

configurationstream_spec

database_name_statement

datainstream_spec

dataoutstream_spec

date_spec

delimiter_spec

duplicates_clause

extract_files_spec

field_format

field_pos

format_spec

generate_spec

if_condition

instream_spec

int_spec

key_column_spec

lit_column_spec

load_column_spec

load_column_spec_mlt

longfile_code_spec

longfile_spec

longfile_spec_mlt

mediumtype_spec

noheader_spec

null_assign

null_condition

null_spec

number_spec

numerical_functions

order_clause

output_column

output_column_list

outstream_spec

packagestream_spec

part_spec

restart

restore_spec

round_or_trunc_spec

scale_spec

select_expression

separator_spec

set_column_spec

set_column_spec_mlt

sequence_number

simple_column_spec

simple_condition

sql_mode

standard_code_spec

standard_date_mask

standard_time_mask

standard_timestamp_mask

stream_extract

stream_format_spec

table_name

table_spec

time_spec

timestamp_spec

usage_spec

user_statement

Keywords

Keywords A - C

Keywords D - E

Keywords F - K

Keywords L - P

Keywords R - S

Keywords T - Z

Terms and Procedures

Data

Application Data

Metadata

Data Stream

Data Format

Format of the Data Stream

COMPRESSED

FORMATTED

FORMATTED BINARY

PAGES

RECORDS

Direction

Data Types

Internal Database Data Types

External Data Types

Converting the Data Types

Unloading LONG Values

Each LONG Value to Be Unloaded in a Separate LONG Data Stream

All LONG Values to Be Unloaded in One LONG Data Stream

HEX Values

Plain Text Values

Loading Binary Values

Loading LONG Values

Each LONG Value to Be Inserted in a Separate LONG Data Stream

All LONG Values to Be Inserted in One LONG Data Stream

Code Attribute for a Data Stream with LONG Values

Medium

Metadata

Metadata of the Application Data

Metadata of the Database Catalog

Metadata of the Transformations

Selecting Data Records

System Table CODEPAGE