## SQLWays - IBM DB2 Version Differences

This chapter describes differences between IBM DB2 8.x, 7.x, 6.x and 5.x versions.

- LOAD Command

### LOAD Command

The IBM DB2 LOAD utility moves data from files, named pipes, or devices into a DB2 table. The load utility is faster than the import utility, because it writes formatted pages directly into the database, while the import utility performs SQL INSERTs.

Options

- CLIENT

  Requirements: IBM DB2 7.1 or later

  Specifies that the data to be loaded resides on a remotely connected client. If this option is not specified the data must reside on the server.

  For example, the following command allows you to load an ASCII text file located on the client to a remote DB2 database.

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

[Main] [Table of Contents]
Copyright © 1999-2003 Ispirer Systems. All Rights Reserved.
SQLWays™ www.ispirer.com.