topic Re: Table Data delete not working in Application Development and Automation Discussions

Table Data delete not working

Former Member — Fri, 10 Nov 2006 20:43:15 GMT

Hi,

I m trying to simply delete all records in a Z table. I insert data into this table from another program. Until 1/2 hr ago both insertions and deletions were working fine. But now suddently the delete program is hanging on statement

DELETE FROM SAPR3.ZMYTABLE.

The table has no lock objects, nor m I explicitly locking the table in the insert program. Please help at the earliest, points will be given to right answer. Thank you for reading.

Re: Table Data delete not working

Former Member — Fri, 10 Nov 2006 20:46:42 GMT

Hi,

If the name of the table of ZMYTABLE then the syntax should be

DELETE FROM ZMYTABLE.

thanks

Re: Table Data delete not working

ferry_lianto — Fri, 10 Nov 2006 20:48:36 GMT

Hi Srikrishna,

Please try to use standard program RADCVBTC to delete all records from your custom program.

OBJ_NAME = <custom table>

OBJ_TYPE = 'TABL'

FCT = 'MDF'

Hope this will help.

Regards,

Ferry Lianto

Re: Table Data delete not working

Former Member — Fri, 10 Nov 2006 22:23:32 GMT

Hi,

Try putting a COMMIT WORK AND WAIT after the DELETE.

Example:

DELETE FROM ZMYTABLE.

COMMIT WORK AND WAIT.

Hope it helps.

Kind Regards,

Gilberto Li