Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

How to Delete data from Database written by Export statement

Francis417
Participant
0 Likes
2,848

Hi Experts,

I'm using the Export to database statement in program A to write some data to the database for passing to program B for further processing using the Import from database statement.

Now in program B, after importing the data from the database and finish processing, I want to clear these data using the Delete from database statement. However, it seems that it is now working. I get the same result from program B when I try to execute it again without first executing program A.

Any idea how I can clear the database after processing in program B.

Thanks,

Francis

1 ACCEPTED SOLUTION
Read only

rubin_luke3
Participant
1,774

Hi Franscis,

Could you please check whether the following link is helpful.

https://wiki.scn.sap.com/wiki/display/Snippets/Import+and+Export+to+Cluster+Databases

Regards,

Rubin

3 REPLIES 3
Read only

rubin_luke3
Participant
1,775

Hi Franscis,

Could you please check whether the following link is helpful.

https://wiki.scn.sap.com/wiki/display/Snippets/Import+and+Export+to+Cluster+Databases

Regards,

Rubin

Read only

0 Likes
1,774

Thanks Luke, got my problem solved.

Read only

Sandra_Rossi
Active Contributor
1,774

cf ABAP documentation - DELETE FROM (data clusters)

DELETE FROM DATABASE dbtab(ar) [CLIENT cl] ID id}