Answer Posted / s

If a column contains nulls and you dont include a null
indicator variable in the program, the program receives a
-305 SQLCODE.
Even if no columns allow for nulls, it may be necessary to
use the null indicator to avoid a -305 SQLCODE. For eg, if
AVG(SAL) is computed and ther eare no employees in the
department, the result is null and a null indicator must be
ccoded on the SQL statement to avoid -305.
EXEC SQL SELECT SNAME
INTO :SNAME:SNAME-INDNULL
FROM S
WHERE SN = :SN-IN
END-EXEC
If SNAME has a value, SNAME-INDNULL contains 0.
If SNAME is NULL, SNAME-INDNULL contains -2.

Similarly, Inserting a NULL also required special handling.
If you are not providing a value for SNAME, a -1 can be
moved to the null indicator associated with the SNAME
column:

MOVE -1 to SNAME-INDNULL

EXEC SQL INSERT INTO S
(SN,SNAME,STATUS,CITY) VALUE
(:SN,:SNAME:SNAME-INDNULL,:STATUS,:CITY)
END-EXEC

Is the primary key a clustered index?

607

---

What is buffer pool in the db2 database?

610

---

can we view the access paths created by dbrm ? how ? thx

6236

---

What parameters are used to control the free space in DB2?

640

---

What is coalesce in db2?

678

---

---

What is a db2 cursor?

618

---

is it compulsory commitment control in journal?

2007

---

What is the use of db2?

584

---

How do you stop a db2 database in linux?

566

---

What is meant by explain?

660

---

How do I optimize a query in db2?

611

---

What is deadlock in db2?

577

---

What is bind package and plan in db2?

591

---

Explain about open switch business continuity software?

560

---

Which are the db2 tools to protect integrity of the database?

686

---