How does DB2 store NULL physically?
Answers were Sorted based on User's Feedback
Answer / s
DB2 stores an additional byte for every nullable column to
indicate whether the column contains an actual value or
null.
Is This Answer Correct ? | 9 Yes | 0 No |
Answer / sachin
db2 every coloumn have prefix .
if its hexa = '00' then coloumn have the null value
and if its other than null then it containx 'ff'
Is This Answer Correct ? | 1 Yes | 1 No |
What is the clustering index in the db2 database?
What is the role of the data page in the db2 database?
How to handle null values in db2
What is a collection?
How to resolve -504 sql code in DB2?
What are the disadvantages of PAGE level lock?
Is it mandatory to use DCLGEN? If not, why would you use it at all?
What is a DB2 access path?
What is buffer pool and list some of them?
What is db2 optimizer?
Define db2 and its databases?
Define predicate?