Interested to Buy Any Domain ? << Click Here >> for more details...
How does DB2 store NULL physically?
- 2 Answers
- 10924 Views
- I also Faced
- E-Mail Answers
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 to resolve -818 error. how to see timestamp token in load module and plan
what is the use of commit ? and what is the syntax?
What are union and union all?
What is index cardinality?
What do you mean by NOT NULL? When will you use it?
What are the different types of base tables?
How to access db2 tables in mainframe?
Explain dclgen.
how to check the table is empty or not?
What are db2 error codes -305 and -407. What is the difference between these 2 error codes ?
Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.
What is the max length of sqlca?
COBOL 
