Closing a Connection

32.3. Closing a Connection

To close a connection, use the following statement:

EXEC SQL DISCONNECT [connection];

The connection can be specified in the following ways:

  • connection-name

  • DEFAULT

  • CURRENT

  • ALL

If no connection name is specified, the current connection is closed.

It is good style that an application always explicitly disconnect from every connection it opened.

Back to top

(С) Виктор Вислобоков, 2008-2010