Answer Posted / srikanth alla

no

What is the difference between bind and rebind in db2?

1396

---

How do you select a row using indexes in db2?

1075

---

What are packages in db2?

972

---

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

1056

---

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

2340

---

List out the three types of page locks that can be held.

1093

---

What is the cobol picture clause of the db2 data types date, time, timestamp?

1012

---

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

1033

---

What is buffer pool?

1033

---

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

4215

---

What is the use of reorg in db2?

1027

---

What is an instance in db2?

987

---

What is precompiler in db2?

960

---

What is dclgen (declaration generator)?

1012

---

What is the connection string to connect to the DB2 Database ?

1062

---