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@xxxxxxxx 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@xxxxxxxx
http://www.iiug.org/mailman/listinfo/informix-list


_______________________________________________
Informix-list mailing list
Informix-list@xxxxxxxx
http://www.iiug.org/mailman/listinfo/informix-list

.