Mainframe, MVS and zOS Discussion

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.

Look at the syntax of the INSERT verb.

Also you could try UNLOAD and LOAD

Pandora-Box wrote: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.

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