connect to MYDB user db2admin using ****@
set schema MYSCHEMAs@
set path MYSCHEMA,current path
@

create table myt (id int not null, ts timestamp default current timestamp, primary key (id))
@
insert into myt values ( 1 ),( 2 ),( 3 )
@


create or replace procedure test(
    in table_name varchar( 30 ),
    in file_path varchar( 100 ),
    out err_msg varchar( 512 )
)
begin
    declare exit handler for sqlexception
    begin
        get diagnostics exception  1  err_msg=message_text;
    end;    

    call admin_cmd('export to '|| file_path ||' of ixf select * from '||table_name);
    set err_msg='Succesfully exported';
end
@

call test('MYT','E:\Sources\9.0.1\db2\main\mrm\database\stored_procs\db2\myt.ixf',?)
@


quit@

create or replace procedure test(
    in table_name varchar( 30 ),
    in file_path varchar( 100 ),
    out err_msg varchar( 512 )
)
begin
    declare sql_stmt varchar( 1024 );
    declare exit handler for sqlexception
    begin
        get diagnostics exception  1  err_msg=message_text;
    end;    

    set sql_stmt='call admin_cmd(''export to "'|| file_path ||'-2.ixf" of ixf select * from '||table_name||''' )';
    set err_msg=sql_stmt;
    execute immediate sql_stmt;
    set err_msg='Succesfully exported';
end
@

call test('MYT','E:\Sources\9.0.1\db2\main\mrm\database\stored_procs\db2\myt.ixf',?)
@