sequential file warning message

[scorpion]

Hi All,

I am getting some warning messages in my director log like below.

Input_Delta,0: Field "LT_SZE" has import error and no default value; data: <empty>, at offset: 202


This is message belongs to one sequential file stage.

Any one has idea?

[surendra_ds]

Hi

The Error comes when u are trying to write into a sequential file. Make sure that all the settings are proper.

[ray.wurlod]

Not correct.

Import errors occur when you are trying to READ.

And is agnostic regarding what U might be doing at the time.

The field in question is empty, but your data type precludes an empty string being a valid value. You need to provide either a Default property or a Null Field Value property or both for this field.

[mcs_dineshm]

There may be data type mismatch,so try it up with some other datatype. Varchar is more preferred if the field contains special characters,characters and numbers