Answer Posted / s

use the WHERE Clause

What is explain in db2?

1020

---

What is database alias db2?

1125

---

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

1240

---

run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

4311

---

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

1101

---

How to run db2 command in windows?

1193

---

What is the use of with ur in db2?

1056

---

Explain about dbrm.

1047

---

What is drop table?

1010

---

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

2329

---

What is a page in db2?

1027

---

How do I add a column in db2?

1048

---

Explain about cursor stability?

1050

---

What are catalog tables in db2?

1049

---

What is schema in db2?

1021

---