8. OpenSQL Statements : Disconnect : Examples: Disconnect
 
Share this page                  
Examples: Disconnect
1. Disconnect from the current database.
exec sql disconnect;
2. On an error, roll back pending updates, then disconnect the database session.
exec sql whenever sqlerror goto err;
...
err:
   exec sql rollback;
   exec sql disconnect;