1备份整个schema下的表
select 'insert into migdev_backup.'|| tabname || '(select * from migdev.'|| tabname || ');' from syscat.tables where TABSCHEMA ='MIGDEV';
1备份整个schema下的表
select 'insert into migdev_backup.'|| tabname || '(select * from migdev.'|| tabname || ');' from syscat.tables where TABSCHEMA ='MIGDEV';
转载于:https://www.cnblogs.com/feng924249386/p/5973546.html