Using COMMIT with SELECT statements

[yahoosirius]

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.

 

[dickiebird]

I have never needed to - who 'advised' you ?

Dickie Bird (-)))

 

[yahoosirius]

I have been advied this by my application vendor - Sybase is the host DB.

 

[nickpark]

By default, Sybase has autocommit turned on.

If you begin transaction then, yes, locks may be retained.

I suggest you take a look at the docs - see auto commit and transaction isolation levels - they should help make things clear.