Answer / s

Updated pages are not written immediately to the DASD. Upto
32 pages can be written with 1 I/O and is called a deferred
write. Asychronous means the SQL request does not wait for
the Write I/O to happen.

COBOL PRECOMPILER ERROR: "XXXXXX" (TABLE) PREVIOUSLY DECLARED OR REFERENCED DCLGEN VARIABLES GETS IMPORTED TWICE FOR ONLY ONE EXEC SQL STATEMENT. WHAT COULD BE THE PROBLEM?

1 Answers  

---

What is bind plan?

0 Answers  

---

wht happens if we close cursor with cursor with hold option?

3 Answers   Valtech,

---

DB2 is a A) data base/data communication system B) data base C) RDBMS D) Programming language

4 Answers   Accenture,

---

What is dbrm? When it will be created?

0 Answers  

---

For Null indicator we have 3 values 0,-1,-2. 0->Not nulll -1->Null -2->Value truncated If ther is any possibility to have any positive value other than 0 in Null indicator.If it is so then when we will get and what is the value?

1 Answers   BNP Paribas,

---

db2 query I have one table with the following details. SNO SNAME DOJ ------ -------------------- ---------- 10 KRISH 2007-03-19 20 REDDY 2007-05-19 30 RRRRR 2007-05-19 40 BBBBB 2008-05-19 50 CCCCC 2009-05-19 60 JJJJJ 2009-05-19 70 JJJJJ 2004-05-19 i want the output in the following format:( no of students joined in each year(no nedd to consider about month and date) year count --------- ---------- 2004 1 2007 3 2008 1 2009 2

9 Answers   TCS,

---

Where can you declare a cursor in a cobol-db2 program?

0 Answers  

---

What is a db2 table?

0 Answers  

---

Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.

2 Answers  

---

What is node in db2?

0 Answers  

---

Which isolation level provides highest data integrity?

0 Answers  

---