Hi all
I'm facing the problem of NULL Value in a FIELD..
I set a stage variable for this FIELD like this svCODE1: IF(isNull(CODE1) or Len(Trim(CODE1))=0) Then 'NULL' else CODE1.
After this I set the derivation at the CODE-Level with the value of scCODE1.
By running i receive the following Message Error:
Fatal ERROR: Null value on the accessor interfacing to Field CODE1.
As output i'm using dataset_File.
Am'i forgeted to set some thing correctly?
Thank's for your reply.
Fatal ERROR Null value on the accessor interfacing to Field
Moderators: chulett, rschirm, roy
-
yollsonlegrand
- Participant
- Posts: 51
- Joined: Fri Nov 07, 2008 8:03 pm
Fatal ERROR Null value on the accessor interfacing to Field
Yollson Empereur
</a>-
yollsonlegrand
- Participant
- Posts: 51
- Joined: Fri Nov 07, 2008 8:03 pm
Ok. if so, where I'm supposing to handel the Null Field value CODE1. I wannt to add that I did the same thing with two other Stage variable in the same Job. That mean that I must change this?ArndW wrote:Stage variables cannot be set to null. Is "CODE1" a stage variable? ...
can you tell me Please how to deal with this Null field value? I'am using data_set stage and not sequence_file stage to avoid this problem.
Thank's for your reply dear arndDW.
Yollson Empereur
