Re: long transaction

jay@ulife.com (Jay Aymond) offerred: +Manzanares <fm@ils-cargo.com> wrote: +>We are working under Informix 5.0. +>If a I select about 100000 records into a temp table using EXEC SQL +>EXECUTE IMMEDIATE, I get error -458 (Long transaction). +>The same statement runs well using DBACCESS. + +Try creating the table using the "with no log option" so that the +inserts will not be logged. That option (with no log) was not available in version 5.0 -- Dave Kosenko davek@summitdata.com Director of Training Services (732) 469-4070 Summit Data Group (an Informix Authorized Education Center)