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

[Ashish Bhatt <ashish_bhatt@HOTMAIL.COM>]

No. I don't think.

Set up a counter and when it reaches 1000 then commit and make counter 0.


----- Original Message -----
From: "Michael Lee" <homestoremike@YAHOO.COM>
To: <SQR-USERS@list.iex.net>
Sent: Thursday, June 06, 2002 8:47 AM
Subject: Can you set commit level inside a insert/select?


> Hi,
> Can you set the commit level (i.e. set commit 1000;)
> inside an insert/select statement?
>
> For example:
>
> begin-SQL
>
> INSERT INTO <TABLE2>
> SELECT FROM <TABLE1>
>
> end-SQL
>
> Usually, I have a two separate procedures, one to
> select and one to insert.  And I keep track of the
> number of rows inserted until it reaches lets say 1000
> rows.  Then I have an if-statement to check to see if
> it's time to commit, and then reset the counter.
>
> However, how would you do manage to set the commit
> level for an insert/select?
>
> Thanks in advance,
>
> Mike
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! - Official partner of 2002 FIFA World Cup
> http://fifaworldcup.yahoo.com
>