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 NULL INDICATOR ? WERE IS THIS USED? AND IF IT IS USED IN FILES CONCEPT? HOW DO WE USE IT?
How many databases are there?
Hi Team, Please tell me, If i don't declare the cursor in the program and i have given open and fetch and close, then what error will get.
What is table space in db2?
What is Skeleton cursor table (SKCT)?
What is concurrency in db2?
what is + sign and -ve sign for sql code ?
What is the purpose of the WHENEVER statement?
What techniques will be used to avoid deadlock??
What is cobol db2?
Can we use select * statement in cobol program without giving field names ???
How will fetch last 5 rows from table in db2