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 |
pls tell me abt the normalization five types....
How to create backup table in db2?
What is lock contention?
How can you count the number of rows from a table tab?
How to update more then one record using update?
What is the use of db2 optimizer?
What is the cobol picture clause of the db2 data types date, time, timestamp?
max number of columns in a db2 table?
I have 1000 rows in a db2 table.I want to update first 100 records,How do I do it?
What should be specified along with a cursor in order to continue updating process after commit?
What are host variables in db2?
How can you compare table column after update and before update?