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 happens to the PLAN if index used by it is dropped?
What is a db2 tablespace?
What is buffer pool in the db2 database?
What is a data page?
What is dclgen in db2?
what is the use of bind parameter, Replace?
How does one remove entries from the SCT02 table?
What does a deadlock mean in DB2?
Can there be more than one cursor open for any program?
What does DML stand for and what are some examples of it?
What are some SQL aggregates and other built-in functions?
How do you find the maximum value in a column in db2?