How Delimited Data Is Processed

To specify delimiters, field definitions can use various combinations of the TERMINATED BY, ENCLOSED BY, and OPTIONALLY ENCLOSED BY clauses. The following topics describe the processing that takes place in each case:

• Fields Using Only TERMINATED BY

• Fields Using ENCLOSED BY Without TERMINATED BY

• Fields Using ENCLOSED BY With TERMINATED BY

• Fields Using OPTIONALLY ENCLOSED BY With TERMINATED BY