it would be FETCH 300 ONLY

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 / anonumous

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

Answer Posted / anonumous

it would be FETCH 300 ONLY

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a cursor in programming?

1113

what is a corelated subquerry?

1170

What os does db2 run on?

1047

What is concurrency?

1304

Name the lockable units in DB2?

1187

Which isolation level provides highest data integrity?

1189

What is host variable?

1112

Can we delete records from view?

1022

How do I add a column in db2?

1090

What is difference between rollback and commit?

1205

What is a db2 package?

1126

How do you select a row using indexes in db2?

1178

What is image copy in db2?

1072

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 ?

2387

Is db2 relational database?

1044