Interested to Buy Any Domain ? << Click Here >> for more details...
How does DB2 store NULL physically?
- 2 Answers
- 10826 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 check the table is empty or not?
why we create view.
How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?
SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .
What does the sqlcode of -818 pertain to?
How does DB2 determine what lock-size to use?
How and when does the db2 enforces the unique key?
How to resolve -917 sql code in DB2?
i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?
How do I delete a column in db2?
What do you mean by cursor?
my project is insurance management system,how to explain my work environment in interview?
COBOL 
