How do I copy data from one Db2® table to another on the same Db2® system?

Scenario: I have data in a Db2® table and want to copy it to another Db2® table. The source and target Db2® tables are on the same Db2® system.

Consider using the FM/Db2 Copy Utility (3.3), instead of the FM/Db2 Export Utility and Import Utility. If the source and target table have different column names, different numbers of columns, or if data type conversions are needed, you can use template re-mapping to map columns in the source table to columns in the target table. In most cases, FM/Db2 performs any data type conversions automatically.

Related tasks

Copying data from one Db2 object to another
Column mapping rules

Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.