It all depends on what u are trying to do with your SELECT Stmt.
1) If you want to fetch all rows no matter what - CURSOR is needed.
2) If you know that all the rows returned are dups and wish to fetch just a single row. You could use SELECT DISTINCT, or FETCH FIRST 1 ROWS ONLY.
3) If all you wanna know is, if the query returns any rows, you could check for the SQLCODE after the query for -811.