Commiting in Blocks

I´m new to Sysbase and I´m working on a stored procedure that I need to commit on blocks of 1000 rows. Is there any parameter that I can set for example <BlockCommit=1000> ? if not, Is there any better solution than using a cursor?

Any help will be appreciated.

Thank you.

PS.: I´m using HP-UX

I don't about about Sysbase, but in SQL 2000 you can create a numeric variable and increment it. You can then check this, and when it reaches a set value, issue a commit statement, then reset the integer back to zero.

HTH

Probably, you can use SET ROWCOUNT statement but you should be careful to skip the last ROWCOUNT number of rows in the subsequent call.

Here is a little documentation about how to use it - SET ROWCOUNT

Hope this helps.

Exterminator, If this code works it is exately what I want. I´ll try it.

Thank you all for replies.