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