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

[Prasanna Menta <pmenta@UMUC.EDU>]

Yes, you need to initialise a counter, once you reach the desired count
you can issue a commit
Prasanna

Michael Lee wrote:
>
> 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