topic Re: INSERT Statement Problem in Application Development and Automation Discussions

INSERT Statement Problem

Former Member — Mon, 03 Oct 2005 20:17:42 GMT

Hi,

I have two tables where i need to copy from one table to another table.

I am retrieving the data using the select statement from the first table into

internal table i_tab1.

now, i need to copy it to second table.

i did use insert statement but its not working if i have duplicate records in the second table.

can i use update statement?

Thanks

former_member185931 — Mon, 03 Oct 2005 20:21:36 GMT

you can use MODIFY instead of Insert, as this will update the record if it is already their in the 2nd table.

Syntax : Loop at I_TAB1.

move-corresponding i_tab1 to <2ndtable name>

modify <2ndtable name>

endloop.

or you can delete the entires from the 2nd table and use this commant

insert <2nd table name> from table <1st table name>

Message was edited by: Jagraj Dhillon

Former Member — Mon, 03 Oct 2005 20:24:27 GMT

Use MODIFY dbtab FROM TABLE itab.

Former Member — Mon, 03 Oct 2005 20:40:08 GMT

Use MODIFY statament in the same way of INSERT:

SELECT * FROM <TAB1> INTO TABLE ITAB1

WHERE .......

MODIFY <TAB2> FROM TABLE ITAB1.

Max

Former Member — Mon, 03 Oct 2005 20:40:29 GMT

Thanks Jagraj and Srinivas. It is a fast response.

I had awarded you both the points. Thanks.

Former Member — Mon, 03 Oct 2005 20:41:44 GMT

Hi Max,

Thanks for the answer. I will award you the points also.

Thanks.