Re: INFORMIX WISH LIST
Glenn Travis wrote:
>
> truncate table 'tablename'
What does this do?
> select a,b,c,... from 'tablename' into 'PERMANENT TABLE'
Like:
INSERT INTO table_name
SELECT a,b,c... FROM nother_table_name
You mean?
> I am very suprised that Informix (technology leader) lacks these two
> critical operations. All the other vendors have it, why not Informix?
Nothing surprises me any more. :-)
Cheers,
--
Mark.
+------------------------------------------------------------------+
|Mark D. Stock - The West Solutions Group http://www.west.co.za |
| The Informix FAQ is at http://www.iiug.org |
|mailto:marks@west.co.za +-----------------------------------------+
|Tel: +27 11 803 2151 |If it doesn't work, force it! |
|Fax: +27 11 803 2189 |If it breaks, it needed replacing anyway!|
|Cell: +27 83 250 2325 |Well, that's how I code anyway! |
+------------------------+-----------------------------------------+