SetNull - CFF Stage

vijaykumarpj · Post by **vijaykumarpj** » Sun Sep 12, 2010 3:07 am

Hi,

I am not able to SetNull in the derivation of transformer, to the target column with CFF as Target. In which, I need to pass the Null field value as 'Low Values'(/x00) in the extended properties of the column, by setting the Nullablity to 'YES'. When, the Job is compiled, the nullablity of the target column is reverting to 'NO' and compiling sucessfully. Then, the job gets Aborts, when we Run the Job.

However, I have achieved the above requirement in the sequential file, by changing the property of the sequential file to Mainframe Cobol Format and following the above process for setting null.

Could you please help me to achieve this in CFF.

vijaykumarpj · Post by **vijaykumarpj** » Sat Oct 02, 2010 12:16 pm

Could you please help me out ?

vijaykumarpj · Post by **vijaykumarpj** » Mon Aug 22, 2011 2:07 pm

We cannot perform this operation in the CFF Stage, instead of this make use of the sequential stage, write as a mainframe cobol format, in the properties tab, wherever, we need the low values, need to pass Setnull () from the transformer, before this Seq stage and then, pass the default null field values as /x00/x00.. depending on the length of the field.

Please, let me know if you need any additional details.