create wrapper drda
@
create server test
   type db2/udb
   version  8 
   wrapper drda
   authorization "db2admin" password "********"
	options (dbname 'test')
@
create user mapping for db2admin server test options
	(remote_authid 'db2admin', remote_password '********')@

@
--ну и для примера:
create nickname test.tables for test.syscat.tables
@
select count(*) from test.tables@

create procedure test_prc (in cnt int)
language sql
begin
    declere cdn cursor with return for
         with tmp(id) as (
             values ( 1 )
         union all
             select id+ 1  from tmp where id < cnt
         )
    select * from tmp;
    open cdn;
end
@

call test_prc( 10 )
@

db2 => create procedure db2admin.test_prc source db2admin.test_prc for server test with return to client all
DB21034E  The command was processed as an SQL statement because it was not a
valid Command Line Processor command.  During SQL processing it returned:
SQL30090N  Operation invalid for application execution environment.  Reason
code = "21".  LINE NUMBER= 1 .
db2 =>