We have multiple update/delete statements inside a sybase stored procedure - each affecting 1000 rows. The total no. of rows affected inside the stored procedure may fill the transaction log. There is no explicit begin or commit transaction statements.
Will each statement be committed automatically? Or will all the statements together be considered a single transaction?