full data load in case of INSERT statement

[Former Member]

Hi!

Requirement is that data needs to be inserted into database table

through INSERT statement but the condition would be that,

if any one of the record is not loaded into the database table

no commit work is going to take place and rollback will take place.

only full data load of data is allowed no partial data load is allowed.

How to handle this after we write the INSERT statement.

thanks

ABAP Developer1

[Former Member]

Hi!

Requirement is that data needs to be inserted into database table

through INSERT statement but the condition would be that,

if any one of the record is not loaded into the database table

no commit work is going to take place and rollback will take place.

only full data load of data is allowed no partial data load is allowed.

How to handle this after we write the INSERT statement.

thanks

ABAP Developer1

[MarcinPciak]

insert into DB_tab_name from table ITAB. "insert all rows at once
if sy-subrc = 0.
  commit work.  "all rows were inserted
else.
  rollback work.   "at least one row was not inserted
endif.

Regards

Marcin

[Former Member]

thanks for all your valuable time