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.

List out the three types of page locks that can be held.

1103

---

My sql statement select avg(salary) from emp yields inaccurate results. Why?

1051

---

Highlight all the advantages that are attached to a package.

1089

---

What action db2 takes when a program aborts in the middle of a transaction?

1110

---

What is a plan and package in db2?

1057

---

What are the full forms of spufi and dclgen and why are they used?

1030

---

Mention data types used in db2 ?

1116

---

What is bind and rebind in db2?

1087

---

How can deadlocks be resolved?

899

---

Is the primary key a clustered index?

1088

---

How do you concatenate the firstname and lastname from emp table to give a complete name?

1030

---

How do I change the column size in db2?

1101

---

Which is faster delete or truncate?

1079

---

What is dbrm library?

1016

---

What is db2? Explain.

998

---