Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Truncate Tables TRBAT and TRJOB on DB level

Hi!

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!

Holger

Not what you were looking for? View more on this topic or Ask a question