各位,我的转存存储过程如下,
CALL SYSPROC.ADMIN_CMD ('LOAD FROM (DATABASE DATA11_2 SELECT * FROM db2admin.TD_PLANTMODEL_TESTS where result_on < ''2014-3-29 7:00:00'') OF
CURSOR INSERT INTO db2admin.TD_PLANTMODEL_TESTS_L1 NONRECOV...
显示全部
各位,我的转存存储过程如下,
CALL SYSPROC.ADMIN_CMD ('LOAD FROM (DATABASE DATA11_2 SELECT * FROM db2admin.TD_PLANTMODEL_TESTS where result_on < ''2014-3-29 7:00:00'') OF
CURSOR INSERT INTO db2admin.TD_PLANTMODEL_TESTS_L1 NONRECOVERABLE');
commit;
alter table db2admin.TD_PLANTMODEL_TESTS activate not logged initially;
delete from db2admin.TD_PLANTMODEL_TESTS where result_on < '2014-3-29 7:00:00';
commit;
结果编译不通过,
SQL0104N An unexpected token "alter" was found following "
". Expected tokens may include: "TRUNCATE".
这是什么问题啊?转存程序有问题吗?我是菜鸟,恳请大家帮忙!
收起