import error and no default value

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Akumar1
Participant
Posts: 48
Joined: Tue May 22, 2007 3:38 am
Location: bangalore
Contact:

import error and no default value

Post by Akumar1 »

Hi dear All,
When we are using column import stage and when we define any column datatype as numeric, integer or decimal and null type condition defined, we are getting below error message in the log.

ColImptrTdr,1: Field "User_Zone" has import error and no default value;
data: <empty>, at offset: 126


Any input will be appreciated.


Regards,
Akumar1
JoshGeorge
Participant
Posts: 612
Joined: Thu May 03, 2007 4:59 am
Location: Melbourne

Post by JoshGeorge »

Your input column is empty and you have not specified a valid default value for this column in column import stage.
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
Post Reply