Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2003
    Posts
    15

    Unanswered: Transaction in stored proc

    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?

    Thanks,
    Sankar

  2. #2
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    In an un-chained(default) mode, all of it is considered 1 single transaction.

    Cheers,

    Willy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •