Using the Bulk Import and Export Utilities
Page 11 of 12

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.

When you customize the control file for import or export, you can choose fixed-width instead of delimited files. In fixed-width files, a NULL value is exported as the word NULL.

In fixed-width export, the example shown above would appears as follows:

7         95        NULL      Happy Birthday

During import, NULL is imported as a NULL value.

When using Cloudview, you can specify a different import or export value for NULL, which you will have to do if the width of the column that contains the NULL value is smaller than 4 (the number of characters in the word NULL).