ADABAS D Load

Top Level

Ordering the Manual

Why Do You Need LOAD?

Why Do You Need LOAD?

LOAD in Interactive Mode

LOAD in Interactive Mode

The Input Screen

Interactive Testing

LOAD Commands and Function Keys

The HELP Function

LOAD Restrictions

Loading Database Tables with DATALOAD

The DATALOAD Statement

Data Types of File Fields

Dimension and Precision of Numerical Values

Format Specifications Related to a File and Other File Options

Format Specifications Related to a File and Other File Options

The Format Specifications DEC, DATE, TIME, and TIMESTAMP

The Format Specifications ASCII and EBCDIC

The Format Specification for the Representation of INTEGERS

Representation of NULL Values in the File

Representation of BOOLEAN Values in the File

COMPRESS for Non-tabular Data

CONCATENATE and CONTINUEIF for Multiple-line Data

Multi-volume Processing with COUNT Option

Selecting Records from the Source File

Selecting Records from the Source File

Inserting NULL Values

Inserting NULL Values

Loading Any Constants

Loading Any Constants

Loading Special Constants

Loading Special Constants

Loading Several Tables in a Single Run

Loading Several Tables in a Single Run

Selection with OTHERWISE

Selection with OTHERWISE

Loading with DUPLICATES Clause

Loading with DUPLICATES Clause

Input of Test Data on the Screen

Input of Test Data on the Screen

DATALOAD with Input Made in Default Format

DATALOAD with Input Made in Default Format

Loading Database Tables with FASTLOAD

The FASTLOAD Statement

Loading with the USAGE Option

Updating Table Columns with DATAUPDATE

Updating Table Columns with DATAUPDATE

Creating Dataextracts with DATAEXTRACT

Creating Dataextracts with DATAEXTRACT

The DATAEXTRACT Statement

Format Specifications for the Output File

Structure of the Target File

Data Formats in the Target File

Options for the Output of Numerical Columns

Output of NULL Values

Text Constants in the Target File

Generating Command Files with DATAEXTRACT

Generating Command Files with DATAEXTRACT

DATAEXTRACT FOR DATALOAD

DATAEXTRACT FOR DATAUPDATE

Test Output on Screen

Test Output on Screen

Loading and Extracting LONG Columns

Loading and Extracting LONG Columns

Loading LONG Columns with DATALOAD

Updating LONG Columns with DATAUPDATE

Extracting LONG Columns with DATAEXTRACT

Database Catalog Migration

Database Catalog Migration

CATALOGEXTRACT TABLE

CATALOGEXTRACT USER

CATALOGEXTRACT ALL

CATALOGLOAD TABLE

CATALOGLOAD USER

CATALOGLOAD ALL

Migration of the Database Contents

Migration of the Database Contents

TABLEEXTRACT TABLE

TABLEEXTRACT USER

TABLEEXTRACT ALL

TABLEUNLOAD

TABLELOAD TABLE

TABLELOAD USER

TABLELOAD ALL

Migration of Catalog and Contents

DBEXTRACT

DBLOAD

The ORACLE Crossloader

Loading an ORACLE Database

Loading the Contents of an ORACLE Table

External Data Formats

External Data Formats

The Loading Process

The Loading Process

The Reasonableness Check

Status Messages During Loading

Status Messages During Data Extraction

Aborting a Run

Transactions

The LOAD Session Log

The LOAD Session Log

Statements in a Command File

Statements in a Command File

Structure of a Command File

SQL Statements in a Command File

Input Data in the Command File

Control Statements in the Command File

Control Statements in the Command File

IF-THEN-ELSE

INCLUDE

SAY

RETURN and STOP

Setting the RETURNCODE

Parameters in the Command File

Parameters in the Command File

Further LOAD Statements

Further LOAD Statements

AUTOCOMMIT OFF/ON

USE SERVERDB

USE USER

USE USERKEY

Setting the SQLMODE

USE TERMCHARSET

IGNORE TERMCHARSET

MESSAGE ON

LOAD Commands

LOAD Commands

RUN Without Command File

RUN with Range Option

RUN with STOP Option

Displaying the LOAD Log File (PROT)

Starting a Command File with RUN

Fetching the Next Statement (NEXT)

Displaying All Statements (SCAN)

Skipping Statements (SKIP)

Closing the Command File

Leaving LOAD (EXIT)

User-specific SET Parameters

User-specific SET Parameters

The Printer Key

The Presen Key

LOAD in BATCH Mode

LOAD in BATCH Mode

Appendix 1: Syntax of the Load Statements

Appendix 1: Syntax of the Load Statements

Appendix 2: LOAD Error Messages

Appendix 2: LOAD Error Messages