How can data from a DB2 table be migrated to another table?

2 years ago
Benjamin Taylor
2 minutes

You can migrate data from a DB2 table to another table using the following methods:

  1. By using the INSERT INTO SELECT statement, you can insert data from the source table into the target table. For example:
INSERT INTO 目标表名 (列1, 列2, 列3, ...)
SELECT 列1, 列2, 列3, ...
FROM 源表名;
  1. By using the CREATE TABLE AS SELECT statement, you can copy the data from the source table to the target table. For example:
CREATE TABLE 目标表名 AS
SELECT 列1, 列2, 列3, ...
FROM 源表名;

This method will create a new destination table and copy the data from the source table to the new table.

  1. By using the LOAD command, you can transfer data from the source table to the target table. First, export the data from the source table into a file using the EXPORT command, and then use the LOAD command to load the data from the file into the target table. For example:
EXPORT TO 文件名 OF DEL MODIFIED BY NOCHARDEL SELECT * FROM 源表名;
LOAD FROM 文件名 OF DEL INSERT INTO 目标表名;

In this example, the EXPORT command exports data from the source table to a file, and then the LOAD command loads the data from the file into the target table.

There are several commonly used methods for data migration. Choose the most suitable method based on specific circumstances.

bannerAds