Answer Posted / anilkumar

do you need to unload more than 2 tables in a single unload step
Then need to specify sysrec01,syrec02 in jcl step
and in sysin
specify like this
select * from tab1 with ur; ---- data extrcat into sysrec01
select *from tab2 with ur; ----- data extract into sysrec02

this sort of jcl's we used in our project
but the same thing is not work for if you used union and
union all in the queries.

Give the name of some fields form sqlca.

1091

---

What are the 2 sqlcodes that are returned?

1196

---

What is db2 purescale?

1012

---

Describe major components of db2?

1097

---

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

1120

---

What is bind in db2?

1055

---

What is the usage of open cursor command?

1103

---

What is null indicator in db2?

1120

---

How to resolve deadlock issue

20153

---

What is load replace in db2?

1003

---

What are db2 tables?

1131

---

What is check constraint. Explain with example.

1114

---

What is the use of dclgen in db2?

1085

---

What is schema in db2?

1025

---

What is a Foreign Key?

1104

---