GregMark

 Profile Answers by GregMark Questions by GregMark

• May 5th, 2007

 

Before knowing about Sybase transaction commit it is first essential to know about Sybase transaction. Sybase transaction is nothing but a number of SQL statements paced and handled between Sybase BEGIN TRANSACTION and Sybase COMMIT or ROLLBACK statement. Say for instance an update statement is placed in between the two statements Sybase BEGIN TRANSACTION and Sybase COMMIT or ROLLBACK statement forming a Sybase transaction. This update statement if it executes successfully then the transaction is committed which refers to Sybase transaction committed.

luisgranados

 Profile Answers by luisgranados 

• May 20th, 2011

 

When you specify the begin tran command, you have to close it with commit tran (if is nested , there must be one commit for each begin)
If you don't specify begin tran, the dml statement will be executed in auto commit mode.

When a commit occurs the user log cache content is flushed to transaction log in cache and then to the transaction log on disk.

Siva Pitchai

• Apr 26th, 2013

 

Can we add a column in between two columns in sybase when the table has some data?

SANTOSH TRIPATHI

• Apr 28th, 2014

 

No you cannot , take the backup of your data redesign the table as per your need restore the data using default values or making the column NULL that you have added

GANAPATHI MASILAMANI

• Jul 3rd, 2016

 

No. You cant, add column will be added in the end