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 |
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 |
[{"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":"","label":""}}]
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21229757