How does DB2 store NULL physically?

Answers were Sorted based on User's Feedback



How does DB2 store NULL physically?..

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

How does DB2 store NULL physically?..

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

Post New Answer

More DB2 Interview Questions

WHAT IS NULL INDICATOR ? WERE IS THIS USED? AND IF IT IS USED IN FILES CONCEPT? HOW DO WE USE IT?

2 Answers   IBM,


How many databases are there?

0 Answers  


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.

6 Answers   IBM,


What is table space in db2?

0 Answers  


What is Skeleton cursor table (SKCT)?

2 Answers  






What is concurrency in db2?

1 Answers  


what is + sign and -ve sign for sql code ?

1 Answers   TCS,


What is the purpose of the WHENEVER statement?

1 Answers  


What techniques will be used to avoid deadlock??

5 Answers   IBM, SUN,


What is cobol db2?

0 Answers  


Can we use select * statement in cobol program without giving field names ???

3 Answers   Zensar,


How will fetch last 5 rows from table in db2

6 Answers  


Categories