Answer Posted / guest

It establish relation between application program and DB2
tables.

How to test SQL -911 error while developing COB-DB2 program

7559

---

define clustering index.

1024

---

What is declare cursor?

1113

---

Explain the contention situations caused by locks?

1070

---

What are union and union all?

976

---

How do you pull up a query which was previously saved in qmf?

1149

---

How is deadlock resolved?

1146

---

Mention some fields that are a part of sqlca.

1016

---

How would you find out the total number of rows in a db2 table?

1050

---

what is the sqlcode -501

13137

---

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

4303

---

What is rebind in db2?

1052

---

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 ?

2322

---

What is cursor in dbms?

1062

---

What is host variable?

1054

---