Skip to Content
Former Member
Nov 30, 2008 at 03:24 PM

Truncate Tables TRBAT and TRJOB on DB level



I am facing with hanging SPAM patch of SAPKB 13 -16.

I am on windows with SAP DB.

Now It is not possible to log onto SAP system

The error is: syntaxerror in program SAPLSFES.

To solve this problem I would like to truncate the both tables TRBAT and TRJOB on DB level.

I connected to SAP DB via "dbmcli commando" and can see the both tables with commando:

>sql_execute select * from tables where TABLENAME='TRBAT'

Can some one please tell me the right procedure/DB-command to truncate both tables?

Thank you very much!