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.

Name the lockable units in DB2?

672

---

What r the comman abends in db2, jcl and cobol???????

1827

---

What is the clustering index in the db2 database?

590

---

How to find the number of rows in a db2 table?

653

---

What is runstats utility in db2?

581

---

---

Where do you specify them?

688

---

What is dbrm? What it contains? When it will be created?

599

---

What do you mean by cursor?

595

---

What happens in bind step in a db2 program?

575

---

what are bind concepts in db2 cobol?

656

---

Explain the function of data manager.

641

---

Why do we bind in db2?

638

---

How do I add a column in db2?

603

---

How do I import data from excel to db2?

621

---

How to check last update on table in db2?

634

---