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.

How many databases are there?

1045

---

can all users have the privilage to use the sql statement select * (dml)?

1158

---

How is a typical db2 batch pgm executed?

1167

---

What are db2 objects?

1037

---

What is bind and rebind in db2?

1128

---

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1098

---

Explain the contents that are a part of dclgen.

1085

---

How to rename a table in DB2 ?

1083

---

What are the contents of a dclmgen?

1115

---

Mention some fields that are a part of sqlca.

1014

---

What is a collection in db2?

1027

---

What types of tables are there in the db2 database?

1046

---

What is the difference between plan and package in db2?

1099

---

What is a db2 collection?

1026

---

What is explain in db2?

1007

---