Hi,
First, thanks for all the features available in ICE.
I know that you keep DML for the enterprise version for commercial purposes.
Even though there are great open source ETL softwares available, I like to run some of the transformations directly in ICE because of its excellent speed.
The DML functions I miss the most are:
1. TRUNCATE TABLE - I know about and actually use the stored procedure which recreates the table. But I think this could be made available without the need for the stored procedure.
2. INSERT INTO ... SELECT ... : INSERTs directlly from the result of a query: I know you can export the result from a query and then load it afterwards and that’s what I currently do, but this seems so awkward and time consuming (and also disk space consuming). But allowing inserts from a query would make it follow the standards and much easier to use in transformations.
3. A way to delete the files used in the dumping and loading routines like the one above since currently I need to dump the result of the query and reload it afterwards. But how can I delete this file from an Infobright connection?
Thank you.
Luis Fernando
