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 action db2 takes when a program aborts in the middle of a transaction?
Can we use select * statement in cobol program without giving field names ???
How can record locking be achieved in those DB2 versions which do not support it?
What is the significance of DB2 free space and what parameters control it?
What is the SQL Communications Area and what are some of its key fields?
What is ACQUIRE/RELEASE in BIND?
if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..
What is null indicator in cobol db2?
If we keep the DCLGEN structure for a table in a copybook and include it in the COBOL program using the COPY statement, will there be any impact during compilation or at any stage of program execution?
what is main use of table space and index object? please its urgent
5 Answers CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro,
what is Static and dynamic linking
What are the four lockable units for DB2?