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
-
Saama
- Premium Member
![Premium Member Premium Member](./images/ranks/premium.gif)
- Posts: 83
- Joined: Wed Nov 22, 2006 6:42 pm
- Location: Pune
-
Contact:
Post
by Saama »
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
- Premium Member
![Premium Member Premium Member](./images/ranks/premium.gif)
- Posts: 83
- Joined: Wed Nov 22, 2006 6:42 pm
- Location: Pune
-
Contact:
Post
by 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
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
-
Contact:
Post
by ray.wurlod »
In the Sequential File stage provide either or both of a Null Field Value or Default Value for the UPDATED_DATE field.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
Saama
- Premium Member
![Premium Member Premium Member](./images/ranks/premium.gif)
- Posts: 83
- Joined: Wed Nov 22, 2006 6:42 pm
- Location: Pune
-
Contact:
Post
by Saama »
Hi Gurus,
where should I provide in sequential file stage.I mean in which tab or which property i should provide.
cheers;
saama
-
Saama
- Premium Member
![Premium Member Premium Member](./images/ranks/premium.gif)
- Posts: 83
- Joined: Wed Nov 22, 2006 6:42 pm
- Location: Pune
-
Contact:
Post
by Saama »
Hi Gurus,
Thanks Very much.
I will mark this topic as resolved.
cheers;
Saama