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

Filed under:
|
|
|

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

Related posts about syntax

Related posts about db2