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 |
Can you Average the Characters ?
What is the latest version of ibm db2?
How do u achieve record level locking in DB2 versions when record level locking is not allowed?
What are the disadvantages of using VARCHAR?
What is dbrm? What it contains? When it will be created?
can i code union in cobol-db2 pgm ?
What are catalog tables in db2?
Which catalog table stores referential constraints?
What is REORG? When is it used?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What is a clustering index?
Can I use LOCK TABLE on a view?