Re: truncate table

Posted in 2005

June C. Hunt — Tue, 13 Sep 2005 14:12:36 -0400 — source: Usenet: comp.databases.informix

OTC wrote: > Campbell, John \\(GE Consumer Finance\\) said: > > > > 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? > > Isn't that XPS only? That is still so, yes. The IDS documentation specifically notes that TRUNCATE is only supported by Extended Parallel Server. -- June Hunt sending to informix-list