RE: Transaction Question

Just use 'RAW' table for that. Starting 10.0xC6, RAW tables can be indexed... This approach works very well in our applications -Alexey -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Dave Sent: Tuesday, April 24, 2007 10:29 AM To: informix-list@iiug.org Subject: Transaction Question Hello All, We have the following transaction situation. Is it possible within a transaction, "begin work" ......"commit work" to insert records to a log table and have those records committed regardless of whether the transaction gets rolled back or committed. In fact it would be especially valuable to have those records in the log table when the transaction get rolled back. Any ideas?? --Dave _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list

Can raw tables have constrains also, like CHECK constraints. This can help in those applications where we can afford loosing data in some tables. "Alexey Sonkin" <alexeys@cidc.com> wrote in message news:mailman.607.1177697892.10648.informix-list@iiug.org... Just use 'RAW' table for that. Starting 10.0xC6, RAW tables can be indexed... This approach works very well in our applications -Alexey

I seem to remember that check constraints are ok, (as well as not null), but not FK. j. -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org]On Behalf Of Data Cruncher Sent: Saturday, April 28, 2007 1:42 PM To: informix-list@iiug.org Subject: Raw Tables Can raw tables have constrains also, like CHECK constraints. This can help in those applications where we can afford loosing data in some tables. "Alexey Sonkin" <alexeys@cidc.com> wrote in message news:mailman.607.1177697892.10648.informix-list@iiug.org... Just use 'RAW' table for that. Starting 10.0xC6, RAW tables can be indexed... This approach works very well in our applications -Alexey _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list

Hi The following paragraph might help you, over the query you are dealing with. RAW Tables RAW tables are nonlogging permanent tables and are similar to tables in a nonlogging database. RAW tables use light appends, which add rows quickly to the end of each table fragments. Updates, inserts, and deletes in a RAW table are supported but not logged. RAW tables do not support indexes, referential constraints, or rollback. You can restore a RAW table from the last physical backup if it has not been updated since that backup. Fast recovery rolls back incomplete transactions on STANDARD tables but not on RAW tables. A RAW table has the same attributes whether stored in a logging or nonlogging database. RAW tables are intended for the initial loading and validation of data. To load RAW tables, you can use any loading utility, including dbexport or the High-Performance Loader (HPL) in express mode. If an error or failure occurs while loading a RAW table, the resulting data is whatever was on the disk at the time of the failure. Recommendation: Do not use RAW tables within a transaction. After you have loaded the data, use the ALTER TABLE statement to change the table to type STANDARD and perform a level-0 backup before you use the table in a transaction. Ref : " http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.admin.doc/admin362.htm " Thanks, Prasanna Alur Mathada "Data Cruncher" <datacruncher4@yahoo.com> Sent by: informix-list-bounces@iiug.org 28/04/2007 23:11 To informix-list@iiug.org cc Subject Raw Tables Can raw tables have constrains also, like CHECK constraints. This can help in those applications where we can afford loosing data in some tables. "Alexey Sonkin" <alexeys@cidc.com> wrote in message news:mailman.607.1177697892.10648.informix-list@iiug.org... Just use 'RAW' table for that. Starting 10.0xC6, RAW tables can be indexed... This approach works very well in our applications -Alexey _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list