首先,以not logged initially方式创建一个表
db2 create table ttt (c1 char(6)) not logged initially
插入一些数据:
然后,以下SQL存储过程为例:
在SQL存储过程中,以EXCECUTE IMMEDIATE 执行
alter table ... activate not logged initially with empty table
CREATE PROCEDURE HUANGDK.truncat_t ( )
DYNAMIC RESULT SETS 1
------------------------------------------------------------------------
-- SQL 存储过程
------------------------------------------------------------------------
P1: BEGIN
declare str_sql varchar(4000);
SET str_sql='alter table ttt activate not logged initially with empty table';
EXECUTE IMMEDIATE str_sql;
END P1
db2 create table ttt (c1 char(6)) not logged initially
插入一些数据:
然后,以下SQL存储过程为例:
在SQL存储过程中,以EXCECUTE IMMEDIATE 执行
alter table ... activate not logged initially with empty table
CREATE PROCEDURE HUANGDK.truncat_t ( )
DYNAMIC RESULT SETS 1
------------------------------------------------------------------------
-- SQL 存储过程
------------------------------------------------------------------------
P1: BEGIN
declare str_sql varchar(4000);
SET str_sql='alter table ttt activate not logged initially with empty table';
EXECUTE IMMEDIATE str_sql;
END P1
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/5718/viewspace-168282/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/5718/viewspace-168282/