topic Re: Truncate DataBase with comands SQL. in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/truncate-database-with-comands-sql/m-p/5356227#M1233158 <HTML><HEAD></HEAD><BODY><P>OK, the truncate start with success. thanks</P></BODY></HTML> Mon, 06 Apr 2009 19:44:28 GMT Former Member 2009-04-06T19:44:28Z Truncate DataBase with comands SQL. https://community.sap.com/t5/application-development-and-automation-discussions/truncate-database-with-comands-sql/m-p/5356225#M1233156 <HTML><HEAD></HEAD><BODY><P>I need delete data of a Z table using SQL commands in SAP, ex.</P><P></P><P>exec sql.</P><P> Truncate table ZTABLE05.</P><P>endexe.</P><P></P><P></P><P>But, When I use this command displeing a dump 'DBIF_DSQL2_SQL_ERROR '.</P><P></P><P>From Uilian Silva.</P></BODY></HTML> Mon, 06 Apr 2009 19:08:57 GMT https://community.sap.com/t5/application-development-and-automation-discussions/truncate-database-with-comands-sql/m-p/5356225#M1233156 Former Member 2009-04-06T19:08:57Z Re: Truncate DataBase with comands SQL. https://community.sap.com/t5/application-development-and-automation-discussions/truncate-database-with-comands-sql/m-p/5356226#M1233157 <HTML><HEAD></HEAD><BODY><P>Try this way</P><PRE><CODE> exec sql. Truncate table "ZTABLE05" " In double quote &amp; no dot in the last endexec. </CODE></PRE><P></P><P><SPAN __default_attr="red" __jive_macro_name="color">a®s</SPAN></P><P></P></BODY></HTML> Mon, 06 Apr 2009 19:15:20 GMT https://community.sap.com/t5/application-development-and-automation-discussions/truncate-database-with-comands-sql/m-p/5356226#M1233157 former_member194669 2009-04-06T19:15:20Z Re: Truncate DataBase with comands SQL. https://community.sap.com/t5/application-development-and-automation-discussions/truncate-database-with-comands-sql/m-p/5356227#M1233158 <HTML><HEAD></HEAD><BODY><P>OK, the truncate start with success. thanks</P></BODY></HTML> Mon, 06 Apr 2009 19:44:28 GMT https://community.sap.com/t5/application-development-and-automation-discussions/truncate-database-with-comands-sql/m-p/5356227#M1233158 Former Member 2009-04-06T19:44:28Z