Using the Preview tab to connect in a PocketBuilder application  Defining Transaction objects for multiple database connections

Chapter 16: Using Transaction Objects

Disconnecting from the database

When your database processing is completed, you disconnect from the database using the SQL DISCONNECT statement:

DISCONNECT;

If you are using a Transaction object other than SQLCA, you must include the USING TransactionObject clause in the SQL syntax:

DISCONNECT USING TransactionObject;

For example:

DISCONNECT USING MyTrans;

NoteAutomatic COMMIT when disconnected When a transaction is disconnected, PocketBuilder issues a COMMIT statement by default.





Copyright © 2004. Sybase Inc. All rights reserved. Defining Transaction objects for multiple database connections

View this book as PDF