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.

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

3090

---

How would the varchar column remarks defined?

1035

---

How do I add a column in db2?

997

---

What kind of database is db2?

974

---

If I have a view which is a join of two or more tables, can this view be updateable?

1082

---

What is rebind in db2?

998

---

What are iseries servers?

1009

---

What does db2 mean?

954

---

Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

1309

---

What is the difference between bind and rebind in db2?

1392

---

Can you tell me how can you find out the # of rows updated after an update statement?

1043

---

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

1102

---

How do I delete a table in database?

974

---

How to create backup table in db2?

1041

---

How to find primary key of a table in db2?

1001

---