External Sets for Import Tasks
When used for an import task, an external set describes the structure, format, and record separator of the external file that contains the data to be imported. It also defines a temporary table, in memory or in the database, in which import data is temporarily stored during the import, and to which you can refer in import SQL statements.
NOTE: A record is complete when reading external sets for import tasks when the number of columns defined in the external set and the record separator are reached.
For example, if the external set is defined with three columns, File Format = Comma Separated Values (CSV) and record separator = \n and the file used for the import contains the following data:
2, abcdef, mmm
the external set will only have two records:
1, abc(\n)def, mmm
2, adcdef, mmm