Re: long transaction
David Kosenko wrote in message <356544a5.203742648@nntp.news.netcom.net>...
>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
>
I've created unlogged temporary tables in version 5. I don't think it works
in the select into temp table clause but you can create a temp table first
with no log, then select into it. With this method you can also control
where the temp table is built also.
It would look like:
create temp table tmp_table (col1 integer, col2 char(12), etc) with no log;
insert into tmp_table select col1, col2, etc from big_table where bla blabla;
Give that a try,
Scott Kolaya