Is there something similar to Oracle Truncate in Informix

[gshan]

I am trying to find if there is something similar to Oracle's Table Truncate in Informix.
In Oracle if we give
Truncate table <tablename> then there is no logging for this DDL statement.
Is there any similar statement for Informix
or is there a way I can turn off logging for a table?
Thanks.

 

[vpshriyan]

Hi,

In Informix database server the DDL are always logged. However, DML can be non-logged and are available under "Raw permanent tables (nonlogging)". You can create nonlogging tables within a logged database on IDS v7.31 or some other versions. There 2 types of tables: STANDARD (logging tables) and RAW (non-logging tables). One can create either a standard or raw table, and can switch table mode from one type to another.

A Non-logged table has following features & advantages:
. Created in logged database
. No constraints or indexes
. Fast loading of very large tables

Syntax:
CREATE RAW TABLE customer (...);
ALTER TABLE customer TYPE (STANDARD);
ALTER TABLE customer TYPE (RAW);

Regards,
Shriyan

 

[mberni]

It seems that IBM provides this command only with Informix XPS ... too bad ...