Search found 1 match
- Sun Apr 29, 2012 12:23 am
- Forum: DB2 INTERVIEW QUESTIONS
- Topic: Number of records fetched in a cursor
- Replies: 3
- Views: 10073
Number of records fetched in a cursor
Hi friends , I need to know the number of records selected by a cursor before processing the first record fecthed by cursor. Does any variable of SQLCA will store the number of records by the cursor ?. Any other possible way apart from using select count(*) with the cursor where clause condition ?