jl*****@gmail.com wrote:
Thanks to everyone for you replies. I seems the approach is radically
different in DB2 requiring the creation of procedures and the use of
cursors (generally frowned upon in SQL Server)
Ehem... if you just state:
SELECT * FROM T
In T-SQL. What do think you're getting if not a cursor with RETURN TO
CLIENT?
The SQL/PSM Standard simply spells it out.
Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab