topic Re: How to Delete data from Database written by Export statement in Application Development and Automation Discussions

How to Delete data from Database written by Export statement

Francis417 — Fri, 29 Dec 2017 02:09:01 GMT

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

Re: How to Delete data from Database written by Export statement

rubin_luke3 — Fri, 29 Dec 2017 03:28:28 GMT

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

Re: How to Delete data from Database written by Export statement

Francis417 — Fri, 29 Dec 2017 09:49:59 GMT

Thanks Luke, got my problem solved.

Re: How to Delete data from Database written by Export statement

Sandra_Rossi — Fri, 29 Dec 2017 10:07:02 GMT

cf ABAP documentation - DELETE FROM (data clusters)

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