create OR REPLACE procedure proc_ifexists(in p_table varchar(100),out v_count Integer)
begin
select count(*) into v_count from syscat.tables where tabname = upper(p_table));
end
...全文
3701打赏收藏
DB2查询某个表数量的存储过程
大佬们谁能帮忙看看这个存储过程有什么问题吗??? create OR REPLACE procedure proc_ifexists(in p_table varchar(100),out v_count Integer) begin select count(*) into v_count from syscat.tables where tabname = upper(p_table)); end