DSXchange

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..

Search on "null_field" length (0) must match field's fixed width. The same sarch retrieved 17 results. One of the them ought to help you.

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.

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.

I applied condition in tranformer stage if IsNull(LAST_UPDATE_DATE) Then '
' 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.

in the sartget sequential file stage property, you should define the "null field value" may be '' or ' ', or you can set for individual fields too.
better define as file property, less effort.

I modified as you directed still i amgetting the same error as before..

Try putting 19 "*" characters in as the Null Field Value property.

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..

edward

in general property of sequential file stage you can set that instead of each column.


Sanjay

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..

sanjay wrote:
in general property of sequential file stage you can set that instead of each column.

Thanks for your response Sanjay.

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..

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..

No.

It's not hard. It's just tedious.

Ray,

I don't see full content of your message because i am not premium member..could you please disable this as premium content..

Thanks...

Thanks you very much Ray..