You can generate a .data file. A .data file, which you
can use to load data into a table, has certain characteristics that
you should be familiar with.
A .data 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.