[ic] export.import on upgrade

David Christensen david at endpoint.com
Mon Dec 5 21:26:58 UTC 2016

> On Dec 5, 2016, at 2:28 PM, David_e at charter.net wrote:
> The main problem is that we are getting a null field error in the customer id field on line 2 of the import. The field has correct data so I am assuming that there is some extra data in the old export that is causing a shift. I see that the file format has changed.

Do you have the exact error message?  It may be helpful to define the PREFER_NULL attribute in that field’s data declaration; i.e.:

Database my_table_name PREFER_NULL field_name


David Christensen
End Point Corporation
david at endpoint.com

More information about the interchange-users mailing list