Re: Can you set commit level inside a insert/select?

[Don Mellen <donm@ONTKO.COM>]

On Thu, 6 Jun 2002, Michael Lee wrote:

> Hi,
> Thanks for all the people who responded.  I must
> reinterate that I am doing an Insert/Select within ONE
> begin-SQL.  I cannot set up a counter to count up to
> 1000 rows inserted, then reset the counter back to
> zero.  That's why I said below that I "usually" do
> that, but in this case, I cannot.

As an alternative; if there's some key (or keys) within TABLE1 that would
divide up the number of rows into manageable chunks, you could call the
insert a few times like ....

   begin-SQL
      INSERT INTO <TABLE2>
      SELECT FROM <TABLE1>
        where key_col = $key
   end-SQL

... possibly processed from an array holding the keys found in TABLE1.

Just a thought.

HTH,
-----------------------------------------------------------------------
Donald Mellen  | Ray Ontko & Co. - Richmond, IN - http://www.ontko.com/
donm@ontko.com |  "In the beginning, there was nothing, which exploded"