SQL Anywhere database - Is PREPARE TRANSACTION same as PREPARE TO COMMIT?

Author

Is PREPARE TRANSACTION same as PREPARE TO COMMIT?

Breck Carter [TeamSybase]

2005-06-23, 11:23 am

Is the PREPARE TRANSACTION some Open Client abomination that really
means PREPARE TO COMMIT?

What does SQL Anywhere do with it?

This line showed up in a production request level log for 9.0.2.3124:

06/20 15:46:42.053 ** REQUEST conn: 11743 STMT_PREPARE
"PREPARE TRANSACTION"

Breck Curious

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com

Nick Elson

2005-06-27, 1:23 pm

Just in case you haven't heard

PREPARE TRANSACTION

is a pure Transact SQL and it was not something we originally
planned to support.

The current index entry for that points to the non-existent
entry which was (from vers 5 Open Server Gateway)

¨ Prepare Transaction statement The Open Server Gateway
does not support the SQL Server Prepare Transaction
statement used by DB-Library in a two-phase commit
application to see if a server is prepared to commit a transaction.

As such it was really just an ASE (okay pre-ASE) feature supported
for old Open Client DB-Library 2PC.

We apparently accept it (undocumented) and there is no reason to suspect
it behaves differently from PREPARE TO COMMIT but I would check the
source of the application using it and find out why [it may just be a
vestige
of a framework the authors used].

But unless you/they are doing 2PC it is probably not an issue.

"Breck Carter [TeamSybase]" < NOSPAM__bcarter@risi
ngroad.com> wrote in
message news:37llb15okfbrc3k
io3fg5kmfa873tjsjt3@
4ax.com...
> Is the PREPARE TRANSACTION some Open Client abomination that really
> means PREPARE TO COMMIT?
>
> What does SQL Anywhere do with it?
>
> This line showed up in a production request level log for 9.0.2.3124:
>
> 06/20 15:46:42.053 ** REQUEST conn: 11743 STMT_PREPARE
> "PREPARE TRANSACTION"
>
> Breck Curious
>
>
>
> --
> SQL Anywhere Studio 9 Developer's Guide
> Buy the book:
> http://www.amazon.com/exec/obidos/A...7/risingroad-20
> bcarter@risingroad.com
> RisingRoad SQL Anywhere and MobiLink Professional Services
> www.risingroad.com

Sponsored Links