DB2 存储过程复制表结构、重命名表、删除表实现，及Mybatis如何调用

----Mybaits调用db2存储过程
 <update id="changeTableName" parameterType="java.util.Map" statementType="CALLABLE">
             call PRO_RENAME_TABLE_CONSTRUCT(
             #{tableName,jdbcType=VARCHAR,mode=IN},
             #{tableLikeName,jdbcType=VARCHAR,mode=IN}
             )
         
  </update>
   <update id="createTableByLike" parameterType="java.util.Map" statementType="CALLABLE">
            call PRO_COPY_TABLE_CONSTRUCT(
            #{tableName,jdbcType=VARCHAR,mode=IN},
            #{tableLikeName,jdbcType=VARCHAR,mode=IN}
            )
  </update>
  
   <update id="dropTableByTableName" parameterType="java.util.Map" statementType="CALLABLE">
            call PRO_DROP_TABLE(#{tableName,jdbcType=VARCHAR,mode=IN})
  </update>



SET CURRENT SCHEMA = LOY;

SET CURRENT PATH = SYSIBM,SYSFUN,SYSPROC,SYSIBMADM,LOY;

CREATE OR REPLACE PROCEDURE LOY.PRO_COPY_TABLE_CONSTRUCT (
    IN TABLEA	VARCHAR(1000),
    IN TABLEB	VARCHAR(1000) )
  SPECIFIC SQL181018205715057
  LANGUAGE SQL
  NOT DETERMINISTIC
  EXTERNAL ACTION
  MODIFIES SQL DATA
  CALLED ON NULL INPUT
  INHERIT SPECIAL REGISTERS
  OLD SAVEPOINT LEVEL
--创建存储过程  根据B表的表结构，创建表A
BEGIN
  declare sSql varchar(1000) ; 
  set sSql='create table '||tableA||' like '||tableB;
  prepare s1 from sSql;
  EXECUTE s1;
END;

SET CURRENT SCHEMA = LOY;

SET CURRENT PATH = SYSIBM,SYSFUN,SYSPROC,SYSIBMADM,LOY;

CREATE OR REPLACE PROCEDURE LOY.PRO_RENAME_TABLE_CONSTRUCT (
IN TABLEA VARCHAR(1000),
IN TABLEB VARCHAR(1000) )
SPECIFIC SQL181019104542563
LANGUAGE SQL
NOT DETERMINISTIC
EXTERNAL ACTION
MODIFIES SQL DATA
CALLED ON NULL INPUT
INHERIT SPECIAL REGISTERS
OLD SAVEPOINT LEVEL
–创建存储过程 修改表明，将表名A改为表名B
BEGIN
declare sSql varchar(1000) ;

set sSql='rename table '||tableA||' to '||tableB;
prepare s1 from sSql;
EXECUTE s1;

END;

SET CURRENT SCHEMA = LOY;

SET CURRENT PATH = SYSIBM,SYSFUN,SYSPROC,SYSIBMADM,LOY;

CREATE OR REPLACE PROCEDURE LOY.PRO_DROP_TABLE ( IN TABLEA VARCHAR(1000) )
SPECIFIC SQL181019104816965
LANGUAGE SQL
NOT DETERMINISTIC
EXTERNAL ACTION
MODIFIES SQL DATA
CALLED ON NULL INPUT
INHERIT SPECIAL REGISTERS
OLD SAVEPOINT LEVEL
–创建存储过程 修改表明，将表名A改为表名B
BEGIN
declare sSql varchar(1000) ;

set sSql='drop table '||tableA;
prepare s1 from sSql;
EXECUTE s1;
end;

==========================

结束语：不积跬步无以至千里，不积小流无以成江河

V: 18612372242 欢迎交流指点。