Re: truncate table

Posted in 2005

Martin Fuerderer — Tue, 13 Sep 2005 18:20:50 +0200 — source: Usenet: comp.databases.informix

Hi, I'm not sure wich book you've been reading. In the manual "Guide to SQL: Syntax" the TRUNCATE statement is described. But this section has the "XPS" icon, which means that this is supported by XPS only. Regards, Martin -- Martin Fuerderer IBM Informix Development Munich, Germany Information Management owner-informix-list@iiug.org wrote on 13.09.2005 16:12:33: > 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