Answer Posted / manasa

testdb

How do I connect my db2 database to ibm?

988

---

What is buffer pool?

1033

---

What is database reorganization?

1056

---

What is the maximum size of varchar data type in db2?

1069

---

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

---

Explain correlated sub-queries.

979

---

What is copy pending status in db2?

1071

---

How to create db2 table in mainframe?

1105

---

Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

2316

---

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

1057

---

How do we specify index to include or not during bind process.

2072

---

What is the role of data manager in the db2 database?

1053

---

what is utility for parm lib

2311

---

What does a deadlock mean in DB2?

1099

---

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3525

---