Commiting in Blocks

[Rabelo]

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

[jp140768]

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

[exterminator]

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.

[Rabelo]

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

Thank you all for replies.