Treatment of NULLS

In a delimited file, a NULL value is exported as an empty field. The following example shows the export of a four-column row in which the third column is NULL:
7,95,,Happy Birthday

Import works the same way; an empty field is imported as a NULL value.

Related concepts
Importing into tables with identity columns
Executing import/export procedures from JDBC
File format for input and output
Related reference
Bulk-Import
Bulk-Export
Examples of bulk import and export
CODESET values for import/export