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 alias in db2?
Explain about rct.
Name some fields from SQLCA.
What is the size of a data page?
what is the use of commit ? and what is the syntax?
What does the RUNSTATS Utility do?
What is a data page?
wht steps we need will coding cobol and db2 pgm ?
What is a DB2 catalog?
In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.
What is filter factor?
Is db2 a mainframe database?