Application Development 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: 

How to Delete data from Database written by Export statement

Francis417
Participant
0 Kudos

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

rubin_luke3
Participant

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

rubin_luke3
Participant

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

0 Kudos

Thanks Luke, got my problem solved.

Sandra_Rossi
Active Contributor

cf ABAP documentation - DELETE FROM (data clusters)

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