Answer Posted / 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.

What is null indicator in cobol db2?

992

---

Why do chiropractors use drop table?

1044

---

What is db2 plan table?

992

---

Explain in brief how does db2 determine what lock-size to use?

959

---

How to retrieve rows from a db2 table in embedded sql?

1326

---

Explain various types of locks in db2?

1081

---

What is the maximum No of rows per page?

1011

---

What is the picture clause of null indicator variable?

1081

---

What is the maximum number of columns in a db2 table?

1214

---

How many databases are there?

989

---

What language is db2 written in?

980

---

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

3090

---

Which isolation level provides maximum concurrency?

1089

---

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

2278

---

What is the use of value function?

1074

---