+6Hi all, I'm trying to map fields to match a SQL table where some need to be Null and others are Not Null. As far as I can see, I've done this correctly in the 2 NullAttributeMapper Transformers (attached screenshots).
Basically I need some to be Null, and others to be Not Null. These have been separated in the screenshots below by 2 NullAttributeMappers.
I've attached the error as well, as this is proving to be quite tricky. Any help is appreciated.
+59Could it be that you've forgotten to add the error message?
Also, I think it could be helpful if you could post a screenshot of the data in Visual Preview's Table View from immediately after the NullAttributeMapper(s)
+6Hi red,
I've since attached them (been one of those days..weeks..possibly longer). You can see the difference between a Null value and a blank one, which is what the issue is - as it should be blank/empty, and not a Null
+44I'm not sure you can write an empty string into a smallint column? So I think that is your problem. FME is trying to be clever and convert the empty string to null but you can't insert a null as that is not allowed for that field either.
+6I'm not sure you can write an empty string into a smallint column? So I think that is your problem. FME is trying to be clever and convert the empty string to null but you can't insert a null as that is not allowed for that field either.
You may be onto something here. In the case I can't write an empty string there is there any way to get around it? I'll speak with our DBA team but I didn't know if a space or otherwise would suffice?
+44You may be onto something here. In the case I can't write an empty string there is there any way to get around it? I'll speak with our DBA team but I didn't know if a space or otherwise would suffice?
I suspect you will have to agree some sort of dummy integer value if nulls are not allowed
