topic Re: modify data base table in Application Development and Automation Discussions

modify data base table

Former Member — Thu, 03 Jan 2008 21:14:30 GMT

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

Re: modify data base table

former_member156446 — Thu, 03 Jan 2008 21:17:03 GMT

modify Ztable from Itab will modify the Ztable based on the primary key fields... there cant be repeated primary keys.

Re: modify data base table

ferry_lianto — Fri, 04 Jan 2008 04:17:25 GMT

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

Re: modify data base table

Former Member — Sat, 05 Jan 2008 19:53:59 GMT

ferry thanks for your Replay

Regards