DSXchange

Hi Gurus,
My design is odbc------------->lookup---->sequential file.

Iam using 2 odbc stages followed by lookup stage and then sequential file stage.

Iam getting the below error.

Sequential_File_6,0: Field "UPDATED_DATE" is null but no null export handling is defined.

In sequential file I defined the properties as first name is column names and reject mode = continue.

plz help me.

cheers;
Saama

Hi Gurus,
I have given incomplete information.one of my input column has NULLS in it.

One of my input column simply looks in this fashion.
created by
NULLS
NULLS
NULLS

Due to this my lookup fails.
Field "UPDATED_DATE" is null but no null export handling is defined.

cheers;
Saama

In the Sequential File stage provide either or both of a Null Field Value or Default Value for the UPDATED_DATE field.

Hi Gurus,

where should I provide in sequential file stage.I mean in which tab or which property i should provide.

cheers;
saama

Hi Gurus,
Thanks Very much.

I will mark this topic as resolved.

cheers;
Saama