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

What is the difference between plan and package in db2?

1048

---

What is the use of with ur in db2?

1009

---

What is meant by union and union all?

955

---

Is it possible to create an Instance in DB2 using DB2 Control Center ?

1049

---

What is scrollable cursor in db2?

1009

---

What is a system catalog table in db2?

1112

---

What is meant by dclgen?

1071

---

What are the rules for db2 programming?

1045

---

How and when does the db2 enforces the unique key?

1040

---

What do you mean by rollback?

942

---

What is the difference between drop table and delete table?

1127

---

How will you return the number of records in table?

884

---

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1062

---

How to check last update on table in db2?

1012

---

What is the cobol picture clause of the db2 data types date, time, timestamp?

1016

---