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

difference between group clause and order clause

1 Answers  

---

What is the picture clause of null indicator variable?

0 Answers  

---

What are the uses of db2 optimizer?

0 Answers  

---

wt is view ? wht r the restrictions for view ?

3 Answers   Verizon,

---

What is the specific need of Plan and..where are the tables in DB2 are physically saved

3 Answers   Infosys,

---

How can you compare table column after update and before update?

5 Answers   Satyam,

---

How does DB2 store NULL physically?

2 Answers  

---

What are iseries servers?

0 Answers  

---

List out the buffer pools in db2

0 Answers  

---

What are db2 objects?

0 Answers  

---

What is cascading rollback?

0 Answers  

---

What is the difference between IN subselects and EXISTS subselect?

1 Answers   HCL, PreVator, TCS,

---