Page 1 of 1

LKUP stage and null handling

Posted: Thu Sep 09, 2010 2:17 pm
by Marley777
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]

Posted: Thu Sep 09, 2010 2:40 pm
by anbu
Set Null Field Value to "" on the sequential file

Posted: Thu Sep 09, 2010 3:08 pm
by Marley777
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.

Posted: Thu Sep 09, 2010 3:11 pm
by mhester
Format tab of the sequential file under Field Defaults.

Posted: Thu Sep 09, 2010 3:12 pm
by Marley777
Thanks anbu and mhester. It works now.