LKUP stage and null handling

Marley777 · Post by **Marley777** » Thu Sep 09, 2010 2:17 pm

Get the warning below when trying to write data to reject files from a lkup stage. We have reject links comming from the lookups and writting to sequential files. Problem is we can't view the data in the sequential files we get no rows, but if we use peeks we see rows. Any ideas. Thanks.

ReinsHierRejects,0: Field "REINS_SPLMT_COL" is null but no null export handling is defined

ReinsHierRejects,0: Export was unsuccessful at record 1; continuing. [new-impexp/file_export.C:1305]

anbu · Post by **anbu** » Thu Sep 09, 2010 2:40 pm

Set Null Field Value to "" on the sequential file

Marley777 · Post by **Marley777** » Thu Sep 09, 2010 3:08 pm

Hi Anbu, the reject link goes to the sequential file out of the lookup stage as a reject link. It won't let us do "" on teh sequential file. Any other ideas. Thanks.

mhester · Post by **mhester** » Thu Sep 09, 2010 3:11 pm

Format tab of the sequential file under Field Defaults.

Marley777 · Post by **Marley777** » Thu Sep 09, 2010 3:12 pm

Thanks anbu and mhester. It works now.