Does anyone know of any good place to find examples of cursors? I have looked in both the Application Programming reference and SQL Reference and have found really nothing....

Thanks!

What are you looking for in particular?

Andy

Need to select individual values from a table, evaluate them, and then display them.

In SQL Server it was kind of like:
DELCARE CURSOR FOR SELECT........

FETCH VALUE
DO SOMETHING TO IT
WHILE @@FETCHSTATUS=1 (or something, meaning more to get)
FETCH THE NEXT ONE
CLOSE CURSOR
DEALLOCATE CURSOR

I've really only done really basic stuff with cursors in DB2 (in stored procedures for returning a result set).

Again, any suggestions would be appreciated.

For DB2 Linux, UNIX, and Windows version 8, look in the SQL Reference Vol 2 for the following SQL statements:

delcare cursor
open cursor
fetch
update (where currrent of cursor)
delete (where current of cursor)

I only have access to te version 7 books, and there isn't a whole lot there. Just says this is DECLARE CURSOR <name>...no real examples

Checked SQL Cookbook, too...

You can download all DB2 manuals from the IBM website. See useful DB2 stuff. The ones in PDF format are searchable (if you have the correct version of Acrobat reader that is free) and they also have PDF hotlinks. I would downlload the entire directory of manuals using a ftp program.