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

What is meant by explain?

0 Answers  

---

How do you concatenate the firstname and lastname from emp table to give a complete name?

0 Answers  

---

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

0 Answers  

---

What can the Locate option of the Repair Utility accomplish?

2 Answers  

---

ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

0 Answers  

---

what is SPUFI ?

2 Answers  

---

What are packages in db2?

0 Answers  

---

Return code 100 means?

6 Answers   Cap Gemini,

---

What is the syntax for FETCH in DB2 ?

0 Answers   MCN Solutions,

---

How would you print the output of an SQL statement from SPUFI?

2 Answers  

---

What error I will get if my select query gives multiple row while executing a Cobol-DB2 program.How can I solve it without using a cursor.

4 Answers   Cap Gemini, Verizon,

---

wht happens if we close cursor with cursor with hold option?

3 Answers   Valtech,

---