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.