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 are the 4 environments which can access DB2 ?

2 Answers  

---

cursor with hold explain ?

1 Answers   Verizon,

---

What does db2 blu stand for?

0 Answers  

---

What is DCLGEN ?

3 Answers  

---

wht steps we need will coding cobol and db2 pgm ?

6 Answers   CGI,

---

---

how to take the back up of the DB2 table.

7 Answers  

---

What are the different types of base tables?

0 Answers  

---

Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

0 Answers   IBM,

---

How can we define a table? How can we apply SEARCH ALL on it ?

1 Answers  

---

What is performance tuning db2?

0 Answers  

---

If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created and How many Plans and Packages will get created while Bind Process?

8 Answers   Accenture,

---

What is a DB2 catalog?

2 Answers  

---