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

I am getting a error multiple row fetched while executing a Cobol-DB2 program.How can I solve it without using a cursor.

8 Answers  

---

how can you save the query in QMF?IS IT POSSIBLE OR NOT.IF POSSIBLW HOW?

1 Answers   Hewitt,

---

can any body explain about plan and pakage in detail....

2 Answers   HSBC, IBM,

---

What is the physical storage length of time data type?

0 Answers  

---

What is null value in db2?

0 Answers  

---

what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??

4 Answers   Xansa,

---

I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?

10 Answers   Fidelity,

---

When Can you be sure that a query will return only one row?

4 Answers   IBM,

---

What is a clustering index?

2 Answers  

---

Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

0 Answers  

---

How do u achieve record level locking in DB2 versions when record level locking is not allowed?

2 Answers   IBM,

---

Mention the downsides of page level lock.

0 Answers  

---