Can you set commit level inside a insert/select?

[Michael Lee <homestoremike@YAHOO.COM>]

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