12.11. Summary
In this chapter you were introduced to the different data movement utilities that come with DB2. The utilities support the following file formats: DEL, ASC, IXF, WSF, and CURSOR.
The Export utility extracts data from a table or view into a file. Only a few options are available in the export command. However, at a minimum, you should specify the output file name (where exported data is stored), its file format, the message file name, and a SELECT statement.
The import utility, on the other hand, inserts data into a specified table or view from a file. You can choose to import to an existing or new table (or view). By default, DB2 only issues one COMMIT at the very end of the import operation. In case of failure during the import, ...
Get Understanding DB2®: Learning Visually with Examples now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
