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 the use of runstats in db2?

1101

---

What is the reason behind not using select * in embedded sql programs?

1099

---

How to connect to db2 database from windows command line?

1053

---

Can we delete records from view?

962

---

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

1266

---

What is the meaning concurrency in the db2 database?

1108

---

What is meant by union and union all?

1006

---

What do you mean by commit and rollback?

1030

---

What is role in db2?

1101

---

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3571

---

What language is db2 written in?

1036

---

How do I delete a table in db2?

1059

---

i want to maintain uniqueness on pdf without make lf??????????

2151

---

How do I import a csv file into db2?

979

---

Which component is responsible for processing sql statements and selecting access paths?

1122

---