# How the import and export procedures process NULL values

In a delimited file, a NULL value is exported as an empty field.

The following example shows the export of a four-column row where the third column is empty:

    7,95,,Happy Birthday

The import procedures work the same way; an empty field is imported as a NULL value.

Parent topic: Importing and exporting data
Related concepts
Methods for running the import and export procedures
Bulk import and export requirements and considerations
Bulk import and export of large objects
File format for input and output
Running import and export procedures from JDBC
Related tasks
Importing data using the built-in procedures
Exporting data using the built-in procedures
Related reference
Examples of bulk import and export
CODESET values for import and export procedures