I work with a former DB2 DBA who is requesting me to insert a space character in a primary key field. I don't like this idea one bit, but I'm not sure how best to approach it.
The table will be a reference table.
My arguments so far:
- Space character and null values are indistinguishable to humans, therefore loses meaning
- A distinct character value is more meaningful
- 'Cuz I said so....
I need some strong arguments!
Space in key
I would say NULL means no value available right now where as space means the values is available and blank.
So, go by business logic rather then by DB2 DBA.
They wanted to put a space to represent an unknown value.
Blank should be for unknown values, not a space character.
Click Here to Expand Forum to Full Width