Table of ContentsPreviousNext

Ispirer
Please, note, that Ispirer SQLWays 6.0 is no longer supported and provided to clients.
You can try out automated conversion of databases and applications with Ispirer Toolkit for free. Download free trial.
Check out the relevant toolkit documentation.
Ispirer DB2 Migration overview.


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
Copyright 1999-2023 Ispirer Systems.
Ispirer and SQLWays are registered trademarks. All other product names may be trademarks of the respective companies.
All rights reserved.