TRUNCATE TABLE in IBM Informix Dynamic Server 10 returns error 201 Syntax error has occurred

Troubleshooting

Problem

There are times where an error 201 is returned when issuing the TRUNCATE TABLE command in IDS V10.00. This document gives a possible solution to the problem.

Symptom

When issuing the following statement

TRUNCATE TABLE tabname

tabname
is the name of a table

The following error is returned

201 : A syntax error has occurred

Cause

This feature was not available in the early versions of IBM Informix® Dynamic Server™ even though it was included in the documentation. This feature is first available in 10.00.xC4.

Environment

The following products and operating systems are effected:

Product Name	Product Version(s)	Hardware Vendor	Operating System
IBM Informix® Dynamic Server™	10.00.xC1 10.00.xC2 10.00.xC3	ALL	ALL

x can be T, U, H, or F depending on your operating system

Resolving The Problem

If you have	Then request
IBM Informix® Dynamic Server™ 10.00.xC1 10.00.xC2 10.00.xC3	IBM Informix® Dynamic Server™ 10.00.xC4 or higher

x can be T, U, H, or F depending on your operating system.

[{"Product":{"code":"SSGU8G","label":"Informix Servers"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Not Applicable","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF025","label":"Platform Independent"},{"code":"PF008","label":"DYNIX\/ptx"},{"code":"PF010","label":"HP-UX"},{"code":"PF015","label":"IRIX"},{"code":"PF016","label":"Linux"},{"code":"PF026","label":"Reliant UNIX"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"10.0","Edition":"Workgroup;Enterprise","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Was this topic helpful?

Document Information

More support for:
Informix Servers

Software version:
10.0

Operating system(s):
AIX, DYNIX/ptx, HP-UX, IRIX, Linux, Reliant UNIX, Solaris, Windows

Document number:
346347

Modified date:
16 June 2018

UID

swg21229757

IBM Support

Tips