import error and no default value; data: <empty>

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
vinodhraj
Participant
Posts: 53
Joined: Mon Sep 12, 2005 6:51 am

import error and no default value; data: <empty>

Post by vinodhraj »

hi,

I am extracting data from the pipe delimter file which consists of nullable columns. I have assigned null field value as " " in the format properties and set $APT_IMPEXP_ALLOW_ZERO_LENGTH_FIXED_NULL = 1.

But still I am receiving "import error and no default value" and the record is getting rejected.

Thanks
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”