Table Data delete not working

[Former Member]

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.

[Former Member]

Hi,

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

DELETE FROM ZMYTABLE.

thanks

[ferry_lianto]

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

[Former Member]

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