Exporting nullable field - Warning

[srini.dw]

Hi,

I am loading data into Sequential file.Before loading data into the file doing Null Handling.Below code .....

If IsNull(Move_EmplData.Addr_Street) Then ''
Else If trim(Move_EmplData.Addr_Street) Then '' Else trim(Move_EmplData.Empl_Addr_Street2)

I am getting this warning in Director

main_program: When validating export schema:
At field "Addr_Street":Exporting nullable field without null handling properties

Thanks
Srini

[ray.wurlod]

Read the warning again.

You are performing an export (= writing in human-readable format).
There are nulls in the data.
You have not provided any property (for example Null Field Value) to tell DataStage how to represent NULL in the target.

If the sequential file is fixed width, the Null Field Value must have precisely the same number of characters as the field width.