![]() |
Using the Bulk Import and Export Utilities
|
|
Treatment of NULLSIn 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). |
|
![]() Cloudscape Version 3.6 For information about Cloudscape technical support, go to: www.cloudscape.com/support/.Copyright © 1998, 1999, 2000 Informix Software, Inc. All rights reserved. |