Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Posts
    2

    Lightbulb Unanswered: Using COMMIT with SELECT statements

    I am using ASA 7 and have been advised to use COMMIT when using SELECT statements in order to prevent locks being left on tables. I have never expereienced this behaviour with any DBMS that I have used and not with Sybase either - Uncomitted Trans in DBWatch+ is always reported as 0.

    I would be grateful for advice either way.

  2. #2
    Join Date
    Mar 2001
    Location
    Lexington, KY
    Posts
    606
    I've only used ASA a little bit, but I've never heard that. Who told you?
    Thanks,

    Matt

Posting Permissions

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