IBM DB2 Migration - Tool

[Geri2]

Hi all,

I have a problem with this f.... Mtk-kit.
Viz I want to transformate a procedure form SQL to DB2.
I import an proc a convert this into DB2.
But if I want to execute this proc I get an error that I don't understand.

For example this:

CREATE PROCEDURE p6188_check_stueli(
IN v_firma SMALLINT,
IN v_option SMALLINT,
IN v_sach_nr VARCHAR(15))
DYNAMIC RESULT SETS 1
LANGUAGE SQL
BEGIN

select ad_name1 from adress;

END

What is wrong in/on/with this proc?

Please help me!!!!

Geri

 

[sathyarams]

How about declaring the statement as a cursor and opening it ?
like
BEGIN
declare c1 cursor for
select 1 from sysibm.sysdummy1;
open c1 ;

END




For db2 resoruces visit

http://www.db2click.com

More DB2 questions answered at

http://www.dbforums.com/f8