Interested to Buy Any Domain ? << Click Here >> for more details...
How does DB2 store NULL physically?
- 2 Answers
- 10842 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 would the varchar column remarks defined?
I have some 3 particular fields ..i want to know which all tables have those 3 fields. Is there any way to identify.. can we know by quering system tables..
What is pagespace?
Can you use max on a char column?
What is copy pending and check pending in db2?
how to copy the host variables from ps file into cobol program other than include statement
What is the difference between static and dynamic SQL?
What is bind in db2?
If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?
What does reorg do in db2?
what is the differences between spufi and qmf and which is better?
4 Answers Accenture, Cap Gemini,
If I have a view which is a join of two or more tables, can this view be updateable?
COBOL 
