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 |
How will you delete duplicate records from a table?
Why do we use cursor?
Can we install 2 different versions of Db2 on same mainframe?
What is the use of runstats in db2?
what is the use of bind parameter, Replace?
What is a system catalog table in db2?
what are the bind parameters?
What are the various locks available?
How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?
what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........
What happens to the PLAN if index used by it is dropped?
What are the various locking levels available?