Re: truncate table stmt question

Hi, > Anyone knows of an unofficial list of features for IDS 10.5 ? Yes. ;) ... but I won't tell anything about it. :-( Then again looking at some more recent release notes I see the following :)) --------------------------------------------------------------------- ... 1.5.2 New Features in 10.00.xC4 IBM Informix Dynamic Server, Version 10.00.xC4 contains the following new features: * TRUNCATE table support ... 1.5.2.1 TRUNCATE Table support TRUNCATE is a SQL keyword that quickly deletes active rows from a table and the b-tree structures of its indexes. The active rows are deleted without dropping the table or its schema, access privileges, triggers, constraints, and other attributes. With TRUNCATE TABLE, you can de-populate a local table and release (or reuse for the same table) the storage space that formerly held its data rows and b-tree structures. For more information, see the Guide to SQL: Syntax. --------------------------------------------------------------------- Maybe this alleviates my admittedly somewhat mischievous comment at the beginning? ;) Regards, Martin -- Martin Fuerderer IBM Informix Development Munich, Germany Information Management Informix URLs list: http://home.arcor.de/mfu1/informix/urls.html IBM Information On Demand Global Conference October 15-20, 2006, Anaheim, California see http://www.ibm.com/events/informationondemand informix-list-bounces@iiug.org wrote on 31.08.2006 00:32:29: > Anyone knows of an unofficial list of features for IDS 10.5 ? > > > J. > > Art S. Kagel escribió: > > Doug Fossmeyer wrote: > > > >>Hello, We recently upgraded to 94fc8. Per TFM, I am attempting to use the truncate table sql. It is generating the illuminating 201 error. The table has no constraints or views. It's data is generated via a trigger from a master table. > >>syntax to date: > >>truncate table yadda; > >>truncate yadda; > >>truncate only yadda; > >> > >>I saw a reference to this functionality being available only in XPS; however Syntax manual for 94 does not give that restriction. > > > > > > From TFM: > > > > TRUNCATE > > > > Use the TRUNCATE statement for quick removal of all rows from a table and > > all corresponding index data. > > > > Only Extended Parallel Server supports this statement, which is an extension > > to the ANSI/ISO standard for SQL. > > > > In effect this only works in XPS (Informix 8.xx). There is an outstanding > > request to include this functionality in one of the next couple of releases. > > You'll have to await the official final features list for IDS 10.50 > > tentatively due out end of 2006Q4. > > > > Art S. Kagel > > _______________________________________________ > > Informix-list mailing list > > Informix-list@iiug.org > > http://www.iiug.org/mailman/listinfo/informix-list > > > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list