Insert data from one table to another in DB2 on mainframes.

[Sushma Rahul]

Hi,

I have two tables. Table-X and Table-Y. Both tables have same number of columns and of same data type for the columns in them. Basically they are replica of each other. Now, I need to copy the rows from Table-X to Table-Y. I think I can use INSERT in a different way here so that using a single INSERT I can use update both the tables. Please guide, if using a single insert I can take data from Table-X and copy it in to Table Y? Any pointers are greatly appreciated.

[nicc]

Look at the syntax of the INSERT verb.

[zprogrammer]

Also you could try UNLOAD and LOAD

[Sushma Rahul]

Also you could try UNLOAD and LOAD

Thanks. I can do that but I am thinking if we can use INSERT itself to do that. I am reading through the INSERT statement to make it work. Thanks for the answers.

[zprogrammer]

As Nicc mentioned you could use insert statement

But if there are more records it is better to have frequent commits or as an alternative you could unload and load data