Direct Command

Disconnect from the current database.

stopdb 

Description

This command applies to DB/2 and ORACLE only.

DB/2

This command disconnects the local application from a DB/2 database. It performs an explicit COMMIT.

Oracle & ODBC

This stops the current database so you can use startdb to start a different database. This does not perform an SQL COMMIT statement. You must explicitly enter a COMMIT to save any database changes made during the session, unless with an ODBC database, the auto-commit mode is switched on (i.e. the default)

This command does execute a ROLLBACK RELEASE so that you do not inadvertently leave bad data in the database.

Example

response to NewDatabase 

   send "stopdb\n to SQL 

   send "startdb payroll\n to SQL