Truncate DataBase with comands SQL.

[Former Member]

I need delete data of a Z table using SQL commands in SAP, ex.

exec sql.

Truncate table ZTABLE05.

endexe.

But, When I use this command displeing a dump 'DBIF_DSQL2_SQL_ERROR '.

From Uilian Silva.

[Former Member]

I need delete data of a Z table using SQL commands in SAP, ex.

exec sql.

Truncate table ZTABLE05.

endexe.

But, When I use this command displeing a dump 'DBIF_DSQL2_SQL_ERROR '.

From Uilian Silva.

[former_member194669]

Try this way

 exec sql.
  Truncate table "ZTABLE05"  " In double quote & no dot in the last
 endexec.

a®s

[Former Member]

OK, the truncate start with success. thanks