Data movement file formats

The Db2 data movement utilities recognize and support four different file formats; they are the following:

• Delimited ASCII (DEL): This file format is used in several relational database management systems. In this format, each row is extracted to a single line. Within each line, data values are separated by a delimiter, a unique character other than data values themselves. By default, the column delimiter is a comma, the row delimiter is a new line character (0x0A), and the character delimiter is a double quotation mark (").

For example, if you export a table data in DEL format using default delimiters, the content could look similar to the following:

"000030","SALLY","C01","MANAGER " 
"000050","JOHN","E01","MANAGER " 
"000110","VINCENZO",&quot...