You can use the workbench to generate a .data file. You can use
a .data file to load data into a table.
When you extract data to a .data file by using the workbench, the file
has the following characteristics:
- Each line contains one row.
- On each line, values are separated by the column delimiter that you specify
in the Extract Data window.
- Character data, binary data, and date or time data values are delimited
with the string delimiter that you specify in the Extract Data window.
- If the string delimiter that you specify also occurs in a set of character
data, the delimiter character is doubled.
- Null values are represented by the omission of the value.
- Binary data is stored by using hexadecimal values. Each byte is represented
by two characters that range from 0 to F.