12.2. Data Movement File Formats
Before learning about moving data between DB2 databases and/or other data sources, it is important to first understand the file formats that the data movement utilities use. You can choose from five different file formats:
Delimited ASCII (DEL)
Non-delimited ASCII (ASC)
PC version of Integrated Exchange Format (PC/IXF)
Worksheet format (WSF)
Cursor
12.2.1. Delimited ASCII (DEL) Format
As the name implies, this file format contains a stream of ASCII characters that are separated by row and column delimiters. Comma (,) is the default column delimiter and the carriage return is the default row delimiter. For character strings, DB2 uses double quotes (" ") as the string delimiter. For example, a DEL file will look similar ...
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.
