--数据库 IMPORT/EXPORT脚本生成--
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
---------------------------------
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
---------------------------------