首页 > 代码库 > 备份db2schema数据

备份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‘;

备份db2schema数据