RE: truncate table

Posted in 2005

Link, David A. (Omaha) — Tue, 13 Sep 2005 10:22:46 -0500 — source: Usenet: comp.databases.informix

I believe truncate table function is currently only available in the XPS product.... -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Campbell, John (GE Consumer Finance) Sent: Tuesday, September 13, 2005 9:13 AM To: informix-list@iiug.org Subject: truncate table 9.40.FC5 Solaris 9 I attempted truncate tablename; truncate table tablename; truncate only table tablename. I get a syntax error for each one. All of the examples from the book return a syntax error. Does it work for anyone else? What am I doing wrong? TIA sending to informix-list sending to informix-list