Skip to Content
author's profile photo Former Member
0
Former Member

modify data base table

Posted on Jan 03, 2008 at 09:14 PM 11 Views

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Ferry Lianto
    Ferry Lianto
    Posted on Jan 04, 2008 at 04:17 AM
    2

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Raj S
    Raj S
    Posted on Jan 03, 2008 at 09:17 PM
    1

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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.