01-03-2008 9:14 PM
Hi,
hallow i need idea,
i doing job that insert data to table in data base but the job is
insert 80% data that that already been there and 20% new data
i use delete and modify the table because i don't success with insert commend ,
there is efficient way to do that?
Regards
01-04-2008 4:17 AM
Hi,
You can use modify statement to update your database table.
If the record exists, system will modify the existing record otherwise it will insert new record.
Otherwise, you can perform data checking with database table when you populate the internal table (only with new data). In this case, you can use insert command instead.
Regards,
Ferry Lianto
01-03-2008 9:17 PM
modify Ztable from Itab will modify the Ztable based on the primary key fields... there cant be repeated primary keys.
01-04-2008 4:17 AM
Hi,
You can use modify statement to update your database table.
If the record exists, system will modify the existing record otherwise it will insert new record.
Otherwise, you can perform data checking with database table when you populate the internal table (only with new data). In this case, you can use insert command instead.
Regards,
Ferry Lianto
01-05-2008 7:53 PM