Data set issue

[Former Member]

Hi Friends,

I have a file on appl server (score file) which i am reading with open dataset 'Read'. after reading the flatfile i do some manipulations using progeram on this imported file. now this manipulated file is sent back to appl server using open data set 'Transfer', so a new file is created on appl server.

This new file created on appl server is uploaded into sap using a standard report using RPTIME00.

Now my problem is the user is running this report unknowingly multiple times. The data in the scroe file is getting filled into the newly created file this is causing the interface to run slow.

(eg scroe file has 1000 records these records are transfered to new file, if multiple times the user runs this interface the new file gets 2000 records , 3000 records and so on this is causing low memory problem)

I want to know wheter we can delete the file created by program after upload or do we have modes in which we can stop this duplicate data entry)

URGENT Pl help

reward pts will be given

Regards,

Quavi.

[meikandan_krishnan2]

Hi ,

If you want this program to be executed once in a day or something like this ,

Maintain a Custom table with Program name , date and time as the key.

Check the values , if there is no entry , the program can be executed for that day , if else cannot.

If the above solution is not suitable means , on every upload delete the data file in the application server.

Regards

Meikandan.

[Former Member]

The user does not know to delete the file, i will have to do this through program. Is there any option of modes in data set.

[Former Member]

once the down load app server delete the record.

else.

add ztable maintain the table upload time.