Answer / lu

you need to declare binary indicator variable....
10 Ind-variable pic s(904) comp.

Answer / biswamoy majumder

To insert a NULL, move -1 to the null indicator, To insert
a valid value, move 0 to the null indicator.
declare separately Null indictor variable in Working-
Storage section.
10 variable-NI pic s9(04) Usage comp.

Answer / yuvaevergreen

IN DCLGEN,
>>"INDICATOR VARS .. ===> NO" indicates the presence of
null variables for the fields in the tables.
>>indicator variable should be declared of type s9(4) comp.
77 DAY-IND PIC S9(4) BINARY.
Move -1 to the indicator variable and use in sql.
exec sql
insert into employee(name)
values(:ws-name:ws-name-ind)
end-exec;
ws-name-ind is the indicator variable which inserts null in
the field ws-name.

Answer / ankitha

you can use value function or null indicators if you want to
handle nulls in program.

how can u retrieve the data from null values using applicaion program.

3 Answers   TCS,

---

Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.

3 Answers   IBM,

---

How many Buffer pools are there in DB2 and what are they?

1 Answers   IBM,

---

How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?

2 Answers  

---

Define declaration generator (dclgen).

0 Answers  

---

what is datacom db?

2 Answers   CSC,

---

How Plan is created while executing the query using SPUFI?

3 Answers  

---

In which column of which DB2 catalog would you find the length of the rows for all tables?

2 Answers  

---

What is the difference between Primary key and unique index?

6 Answers  

---

What is meant by a unit of recovery?

1 Answers  

---

How can the duplicate values be eliminated from db2 select?

0 Answers  

---

What are simple, segmented and partitioned table spaces ?

1 Answers   TCS,

---