assume ther are 5000 records in a database and want to fetch using cursor. curso

assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it

Question Posted / akila

1 Answers
3192 Views
TCS, I also Faced
E-Mail Answers

assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 ..

Answer / anonumous

it would be FETCH 300 ONLY

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More DB2 Interview Questions

How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?

2 Answers IBM, Tech Mahindra,

What is an instance database?

0 Answers

What is consistency token in db2?

0 Answers

What is the difference between spufi and qmf?

0 Answers

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

0 Answers

I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01- JAN-2007 TO 01-JAN-2008?

6 Answers Perot Systems,

What action db2 takes when a program aborts in the middle of a transaction?

0 Answers

What is database manager in db2?

0 Answers

For Read Stability locks are not applicable for phantoms, What is Phantoms?

2 Answers

what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)

4 Answers IBM,

What technique is used to retrieve data from more than one table in a single SQL statement?

9 Answers CTS, IBM, TCS,

how do you resolve -805?

3 Answers HCL,

For more DB2 Interview Questions Click Here