Hi all,
In Oracle you can pass parameters to cursors i.e.
cursor myCursor(name_c ity varchar(50), population integer) is
select * from cities
where name = name_city and
num_people = population;
Can you do the same thing in DB2?
All I can see is:
DECLARE myCursor CURSOR WITH RETURN FOR
and this syntax doesn't allow for parameters...
Thanks!
In Oracle you can pass parameters to cursors i.e.
cursor myCursor(name_c ity varchar(50), population integer) is
select * from cities
where name = name_city and
num_people = population;
Can you do the same thing in DB2?
All I can see is:
DECLARE myCursor CURSOR WITH RETURN FOR
and this syntax doesn't allow for parameters...
Thanks!
Comment