Regarding Lookup stage

Saama · Post by **Saama** » Mon Apr 30, 2007 5:13 pm

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

Saama · Post by **Saama** » Mon Apr 30, 2007 5:26 pm

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

ray.wurlod · Post by **ray.wurlod** » Tue May 01, 2007 3:52 am

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

Saama · Post by **Saama** » Tue May 01, 2007 10:47 am

Hi Gurus,

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

cheers;
saama

Saama · Post by **Saama** » Tue May 01, 2007 10:53 am

Hi Gurus,
Thanks Very much.

I will mark this topic as resolved.

cheers;
Saama