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 |
Where can you declare a cursor in a cobol-db2 program?
what is the use of cursors?
Can one database have multiple instances?
In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?
What does DSNDB07 database do?
What is multi row fetch in db2?
Can we declare DB2 HOST variable in COBOL COPY book?
How to rename a table in DB2 ?
How many buffer pools are there in DB2?
On the create tablespace, what does the CLOSE parameter do?
If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI
What is the difference between base table and view?