DSXchange

Hi All,

I getting following warning

Sequential_File_3: When checking operator: When validating export schema: At field "Time": Exporting nullable field without null handling properties

when Nullable Column is set Yes.

However, this warning goes off when when I change Nullable from yes to No.

I am wondering what happen when there is passes of Null value in that column as it has been set to not Null?

thanks
Prashant

They will be rejected, if you have a reject stream.

Srinivas

wht if i want to pass those values also with out rejecting.....then ?


Thanks

Prashant

You need to apply functions / transformations such as handle_null.

srinath,

But we wont get Null in the Target If we apply the some handle_null tranfermations/derivatives .

As we want Null in the target with no warnings at all.

Thanks

Prashant

If you want nulls in a sequential file column then set that column's definition to "nullable yes" and in the sequential file format set the "null field value" attribute to \000

Hi,

You have to handle null by using different inbuild functions. For example, you can use this logic:

If IsNull*<Field-Name>) = 1 Then space(<Length of the Field>) Else <Field>.. This will work.

Regards
Amitava

But amitava, first you need to read the file before you apply any NullHandling function.