Answer Posted / nans

Select FIELD1 From <TABLENAME> As Temp Group By FIELD1 Having
Count(*) >1;

What is check constraint. Explain with example.

642

---

What is buffer pool and list some of them?

628

---

How to restart a DB2 program?

1362

---

B37 abend during spufi?

980

---

What does runstats do in db2?

607

---

---

How to resolve deadlock issue

17971

---

How do I import a csv file into db2?

559

---

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 ?...

3790

---

Can we update view in db2?

560

---

What is check constraint in db2?

606

---

Before you give the explain statement, what are the prerogatives?

579

---

What does reorg do in db2?

576

---

What is difference between alias and synonym in db2?

643

---

What is a db2 tablespace?

600

---

What is the meaning concurrency in the db2 database?

632

---