Table of ContentsPreviousNext

Ispirer             Ispirer


Ispirer SQLWays Database Migration Software

LOAD Command Options

Syntax

LOAD [CLIENT] FROM filename | pipename | device OF filetype
LOBS FROM lobpath MODIFIED BY filetype_mod METHOD load_method
[SAVECOUNT n] [ROWCOUNT n] [WARNINGCOUNT n] [MESSAGES message_file]
INSERT | REPLACE | RESTART | TERMINATE INTO table_name [(column {, column})]

Options

The CLIENT option is available in IBM DB2 7.1 or later.

Example

This example uses the LOAD command to load an ASCII text file to a IBM DB2 table.

LOAD FROM customers.txt OF del MESSAGES customers.log INSERT INTO customers 

Table of ContentsPreviousNext
Ispirer             Ispirer
Copyright © 1999-2014 Ispirer Systems Ltd. Ispirer and SQLWays are trademarks of Ispirer Systems Ltd. All other product names may be trademarks of the respective companies. All rights reserved.