SQL Query to truncate table in IBM DB2
Posted
by Cshah
on Stack Overflow
See other posts from Stack Overflow
or by Cshah
Published on 2010-06-09T14:57:07Z
Indexed on
2010/06/09
15:32 UTC
Read the original article
Hit count: 349
Hi,
Can any one give me the syntax to truncate a table in IBM DB2. I m running the following command: truncate table tableName immediate;
The eror is DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=table;truncate ;JOIN , DRIVER=3.50.152 Message: An unexpected token "table" was found following "truncate ". Expected tokens may include: "JOIN ".. SQLCODE=-104, SQLSTATE=42601, DRIVER=3.50.152
The syntax matches the one specified in the reference docs of IBM : http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.sqlref/db2z_sql_truncate.htm
© Stack Overflow or respective owner