备份db2schema数据

select  'insert into migdev_backup20160820.'||tabname||'(select * from migdev.'||tabname ||');' from syscat.tables  where  tabschema ='migdev';

 

 

select  'delete from migdev_backup2016082020.'||tabname||';'from syscat.tables.tables where Tabschema ='migdev_Backup20160820‘;

posted @ 2016-10-03 21:02  924249386  阅读(1240)  评论(0编辑  收藏  举报