Import and export statements for all tables in the DB2 Automatic Generation Mode

Import and export statements for all tables in the DB2 Automatic Generation mode objective: to facilitate data migration between different databases. SQL code www.2cto.com SELECT 'db2 EXPORT TO '| tabname | '. del of del modified by coldel @ CODEPAGE = 1208 MESSAGES '| tabname | '. expout SELECT * FROM '| tabname AS Exports, 'import from' | tabname | '. del of del modified by codepage = 1208 COLDEL @ MESSAGES '| tabname | '. impout replace into '| tabname AS Imports FROM syscat. tables WHERE tabschema = CURRENT schema