Sybase Question:
Download Questions PDF

What is a good example of a transaction in Sybase?


This answer is geared for Online Transaction Processing (OTLP) applications.

To gain maximum throughput all your transactions should be in stored procedures - see Q1.5.8. The transactions within each stored procedure should be short and simple. All validation should be done outside of the transaction and only the modification to the database should be done within the transaction. Also, don't forget to name the transaction for sp_whodo - see Q9.2.

The following is an example of a good transaction:
/* perform validation */
select ...
if ... /* error */
/* give error message */
else /* proceed */
begin transaction acct_addition
update ...
insert ...
commit transaction acct_addition

Download Sybase Interview Questions And Answers PDF

Previous QuestionNext Question
What is a natural key in Sybase?Why not max out all my columns Sybase?