topic Re: Insert and modify in Application Development and Automation Discussions

Insert and modify

Former Member — Thu, 20 Apr 2006 12:30:45 GMT

Hi Experts,

I have an internal table itab with data.

i hace db table ztab.It has 0 entries.

if i want to populate data from itab..which is better method..is Insert or modify

in some cases i got short dump when using :

insert ztab from table itab.

this ztab is copied from ztable(in se11,copy option is there)

But when i use :

modify ztab from table itab..it is exicuting fine.

Can any body give me clarification on this?

Thanks in Advance.

Re: Insert and modify

Former Member — Thu, 20 Apr 2006 12:31:48 GMT

Use INSERT when you insert fields in the database.

MODIFY to change existing row or insert if not available.

You might have got error if you try to insert a record with the same key fields.

Message was edited by: Wenceslaus G

Re: Insert and modify

Former Member — Thu, 20 Apr 2006 12:33:30 GMT

Hi Jak,

THe insert will throw a short dump if you try to enter a row with same set of primry key field values..

modify will change the contents of the existing row if the set of key field values are same..

so it is better to use MODIFY as it updates if the entry is not found..

regards'

satesh

Re: Insert and modify

suresh_datti — Thu, 20 Apr 2006 12:36:19 GMT

Hi Jak,

MODIFY: Inserts new lines or updates existing lines of a database table.

The short dump with insert may be due to a duplicate entry.

If you are not sure if an entry with the same key exists or not it is better to use MODIFY always..

Regards,

Suresh Datti

Re: Insert and modify

Former Member — Thu, 20 Apr 2006 12:37:33 GMT

I think it depends on what you really want to do.

Anyway if your trx have to create and not update the records, it's better to use INSERT.

The stament INSERT <TABLE> FROM TABLE <ITAB> can get a dump if there are several records with the same key.

Max

Re: Insert and modify

Former Member — Thu, 20 Apr 2006 12:37:40 GMT

INSERT ....only inerts data into datadabe table

MOdify ... inserts data when no similar entry is present; it modify if similar entry is present.

According to me for ur case u should use

INSERT dbtab FROM TABLE itab ACCEPTING DUPLICATE KEYS

because when u insert into data base from internal table ;

it will give dump if similar record are present in internal table

i mean that data which ur inserting from itab is already present in database table hence ur getting dump.

please revert bach if solved.

reagards

manoj

Message was edited by: Manoj Gupta

Re: Insert and modify

Former Member — Thu, 20 Apr 2006 13:34:33 GMT

Hi,

if u want to insert data into database tables use INSERT satetment by using ACCEPTING duplicate values.your program gives short dump because ur passing the primary key more than once.Try to see that primary key feild value in ITAB should exist once.If u want to modify database table u can use MODIFY satement.