Answer / s

NULL Value indicates the absence of a value. DB2 treats
NULL as an actual value and is not equal to blank, zero or
empty string.

The default value of a CHAR data type is blanks, VARCHAR is
empty string and INT,SMALLINT,FLOAT etc is 0.
NULL is not equal to any of the above.

NULLs does not satify any condition in the SQL except when
IS NULL predicate is used. Null can be used at times when
you cannot specify a value for a column, eg middle names,
not everyone has middle names.

Answer / sunil1405

A null value indicates that there is blank value in the
column field. It takes one byte of storage. Null value
requires special prog. to be handled in the app. prog

Comment whether the cursor is closed during commit or not.

0 Answers  

---

How do you check for a null value in a db2 column?

2 Answers  

---

What is catalog database in db2?

0 Answers  

---

Which one allows duplicate values Union or Union All ?

3 Answers  

---

what is Static and dynamic linking

1 Answers   Virtusa,

---

Which is faster delete or truncate?

0 Answers  

---

What is lock contention?

1 Answers  

---

For update of a row in cursors, when do we move value into host variable in cobol progrm? is it before open or before fetch ?

2 Answers   iGate,

---

How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)

2 Answers  

---

What is a page?

2 Answers  

---

What else is there in the PLAN apart from the access path?

1 Answers  

---

db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.

1 Answers  

---