Skip to Content
Former Member
Jun 24, 2014 at 08:29 PM

question on autcommit of transaction and database configuration


I have a ase 12.5 with following setting on a dev server:

select into/bulkcopy/pllsort : true

ddl in tran: true

when run a pb app without autocommit setting. It is fine.

but on my production server, same db have different option setting:

select into/bulkcopy/pllsort : false

ddl in tran: false

then run same app, the transaction from pb app not commit, cause lot of lock and crash app.

So what the relationship between pb transaction autocommit attribute and sybase ase database dboptions setting?