Null handling in Sequential Files for decimal fields

[sumesh.abraham]

Hi,

I have a situation where in i am reading from a sequential file and after some processing writing to a sequential file. It is a '|' delimited file.
I have decimal fields which are nullable.ex;UNIT_RETAIL(20,4)

Warning: When validating export schema: At field "UNIT_RETAIL": "null_field" length (0) must match field's fixed width (22).
Warning:When validating export schema: At field "UNIT_RETAIL": Exporting a fixed length field with a "null_field" of length 0 will prohibit a re-import of this field.

If there is a value in the nullable field,there is no issue.
only when it is empty I get the problem
If i give Null Field Value=''... it reads those decimal fields but gives warnings.
If I give Null Field Value=' ' (22) spaces it gives a diff warning saying no default value defined for a nullable field.

So i want to know how to handle the field when the source data is actually null.

[ArndW]

Using " " (22 spaces) is the correct way to do it. What is the exact error you get when you use this value?

[sumesh.abraham]

If I give Null Field Value=' ' (22) spaces it gives a diff warning saying no default value defined for a nullable field.

What could be causing this warning.

[ArndW]

How can we answer if you don't post the warning you get?

[throbinson]

Search the forum for;
APT_IMPEXP_ALLOW_ZERO_LENGTH_FIXED_NULL

Set this to true and it should allow a zero length ('') for the NULL value in the decimal fixed width field upon export.