Re: truncate table stmt question
- From: Jean Sagi <jeansagi@xxxxxxxxxxxxx>
- Date: Wed, 30 Aug 2006 22:32:29 +0000
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
.
- References:
- truncate table stmt question
- From: Doug Fossmeyer
- Re: truncate table stmt question
- From: Art S. Kagel
- truncate table stmt question
- Prev by Date: Re: truncate table stmt question
- Next by Date: Re: truncate table stmt question
- Previous by thread: Re: truncate table stmt question
- Next by thread: Re: truncate table stmt question
- Index(es):
Relevant Pages
|
