Null Handling
Moderators: chulett, rschirm, roy
Null Handling
Hi All,
I am trying to load data into sequential file however i am getting following error when the source column coming as null.
When validating export schema: At field "LAST_UPDATE_DATE": "null_field" length (0) must match field's fixed width (19)
Seq file definitions..
column LAST_UPDATE_DATE
sqltype timestamp 38
nullable yes
description none
file format
delimiter string \31
null field value ''
quote none
Could anbody throw some light on this..
Thanks in advance..
I am trying to load data into sequential file however i am getting following error when the source column coming as null.
When validating export schema: At field "LAST_UPDATE_DATE": "null_field" length (0) must match field's fixed width (19)
Seq file definitions..
column LAST_UPDATE_DATE
sqltype timestamp 38
nullable yes
description none
file format
delimiter string \31
null field value ''
quote none
Could anbody throw some light on this..
Thanks in advance..
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
I applied condition in tranformer stage if IsNull(LAST_UPDATE_DATE) Then 'us1aslam1us wrote:Null Field Value property of the "LAST_UPDATE_DATE" must have the same length as the fixed-width field length. Go to the column properties and add 19 spaces for the field.
' Else LAST_UPDATE_DATE, but this condition didn't work.
Please let me know where can i find column properties to define 19 spaces..
Thanks in advance..
Edward, the transform action doesn't affect this message. You need to right-mouse click on the column in the sequential file stage, then do and "edit row" and either explicitly set or remove the attribute there.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Thanks for your response Sanjay.sanjay wrote:
in general property of sequential file stage you can set that instead of each column.
Could you please let me know where do we set up??
In sequential file i defined the following properties for under Format
Field defualts:
Delimeter = comma
Null Field value =''
Quote = none
Please advise..
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
No.edward_m wrote:Thanks..i have 97 nullable columns.So its hard for me to define '*' to each and every column based on their length.
Is there any alternative solution ??
Thanks in Advance..
It's not hard. It's just tedious.
Last edited by ray.wurlod on Thu Jul 05, 2007 11:41 am, edited 1 time in total.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: