DSXchange

Thanks Nick. Thanks everybody. I will try to mess with the settings and see if anything improves.

I do have a reject link coming out of the xfm. From what I can see the same column in the reject file is set to Nullable = "Yes". If there is some other property than I haven't set it.

Ok So I set that environment variable to True and ran the code again. It doesn't look like it gave any additional error messages:



- L

I've set it everywhere except for the actual CFF stage that I used to read the file. It won't let me set the field as Nullable there for some reason. Everywhere else has the field as Nullable = Yes.

Yes I set the field as Nullable in the Dataset defnition. It is also Nullable in the database.

Hi, Thanks for the quick reply. I'm doing currently doing this and landing it into a dataset. IF IsNULL(In.CDKFRLU2_CLS_DT) THEN SetNull() ELSE In.CDKFRLU2_CLS_DT It is giving me the following warnings: xfmBuild_RollP_Fmt: When checking operator: When binding input interface field "input0Int8CD...

Hi, I'm reading a Complex Flat File which as a date field that sometimes contains NULL value. I use a Split Subrecord stage to flatten the file and then map this date field to output defined as date. When the incoming value is NULL the output turns into **********, which causes a problem when I try ...