Setting No in Nullable Column

Prashantoncyber · Post by **Prashantoncyber** » Thu Jun 16, 2005 4:25 am

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

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Jun 16, 2005 4:35 am

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

Prashantoncyber · Post by **Prashantoncyber** » Thu Jun 16, 2005 4:50 am

Srinivas

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

Thanks

Prashant

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Jun 16, 2005 5:04 am

You need to apply functions / transformations such as handle_null.

Prashantoncyber · Post by **Prashantoncyber** » Thu Jun 16, 2005 5:52 am

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

ArndW · Post by **ArndW** » Thu Jun 16, 2005 6:01 am

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

gh_amitava · Post by **gh_amitava** » Wed Jun 22, 2005 1:47 pm

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

amsh76 · Post by **amsh76** » Wed Jun 22, 2005 5:04 pm

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