topic Re: difference between batch update and insert in Application Development and Automation Discussions

difference between batch update and insert

Former Member — Mon, 01 Oct 2007 07:47:29 GMT

Hi all,

What is the difference between batch update and batch insert.

I want to update the mm02 transaction's mara-volum and mara-voleh fields.

What should be my route?

Thanks.

Former Member — Mon, 01 Oct 2007 07:54:39 GMT

Hi,

<b>Batch Update</b>

1.current data only

2.continous changing of data

3.1 year data is present

4.only one record is processed at a time

5.data is present in 2d format

<b>Insert</b>

1.Current+historical data

2.Used for reprting and analysis

3.Non volatile in nature

4.5-30 yrs of data is stored

5.Group of records processed at a time

6.Data is present in muti dim format

Former Member — Mon, 01 Oct 2007 08:11:06 GMT

good

INSERT - Add a new record into the database table.

UPDATE - If record is available its update the record otherwise it creates a new record.

thanks

mrutyun^

Former Member — Mon, 01 Oct 2007 08:12:14 GMT

Thanks all repliers.

Do I have to use any function....