DB2中执行动态SQL的例子
create procedure referesh_zhaogw(in odd_table_name varchar(100), in ods_table_name varchar(100))language sql
begin
declare sSql varchar(1000) ;
set sSql = 'create table ' || ods_table_name ||
' as select * from ' || odd_table_name ;
prepare s1 from sSql;
execute s1;
end;
页:
[1]