SetNull - CFF Stage
Posted: 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.
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.