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

Explain dclgen.

1142

---

What is query_cache_limit?

927

---

What is check constraint. Explain with example.

1042

---

What do you mean by commit and rollback?

972

---

What is the picture clause of null indicator variable?

1080

---

What is coalesce in db2?

1052

---

How can the duplicate values be eliminated from db2 select?

1039

---

What does db2 mean?

954

---

Explain about rct in db2?

1043

---

How can we retrieve the total number of records in RPG & CLLE?

577

---

What is a plan and package in db2?

1042

---

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

11612

---

What is db2 command?

962

---

What is cursor with hold option in db2?

1009

---

Before you give the explain statement, what are the prerogatives?

968

---