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 maximum No of rows per page?

1063

---

What is a dbrm in db2?

1018

---

Mention the definition of cobol in varchar field.

1241

---

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2210

---

What is meant by union and union all?

1006

---

Explain the function done by data manager?

1273

---

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

1024

---

What is host variable in db2 cobol?

1069

---

How to check table size in db2 sap?

1029

---

How do I optimize a query in db2?

1095

---

How to create db2 table in mainframe?

1150

---

How to fetch the last row from the table in SQL (db2)?

1645

---

What kind of database is db2?

1030

---

Define data page.

1056

---

What is isolation level in db2?

995

---