Can we use where clause while fetching the records

ritesh pandey · New User Joined: 09 Feb 2007 Posts: 11 Location: Pune

Can we use where clause while fetching the records from db2 through cursor in db2?

dbzTHEdinosauer · Posted: Mon Sep 15, 2008 6:09 pm

yes.

keep in mind, that for embedded sql, a cursor is the only way to return more than one row.

so the difference between a cursor and a singleton-select is the expected return for a singleton-select is no more than one row.

so, anything that you can code for a singleton-select you can code for a cursor.

update cursors are only restricted in that you can not order them.

Siddharth Bahirsheth · New User Joined: 23 Jul 2007 Posts: 16 Location: Mumbai

I think he mean to say..a FETCH CURSOR query ...Can we use a where clause in a FETCH CURSOR .

Shobana Bhaskar · Posted: Tue Sep 16, 2008 2:22 am

You have to include WHERE clause in DECLARE CURSOR statement. You cannot have in FETCH statement. Fetch statement will get the values from table for the filters (WHERE clause) defined in DECLARE CURSOR statement.