Closes the connection(s) to a database. In addition, all cursors opened for that connection are automatically closed.
||The connection name.
||Disconnects all connections (including automatic connections made when the INIT option of the SQL Compiler directive is used).
||Disconnects the current connection. The current connection is either the most recent connection established by a CONNECT statement
or a subsequent connection set by a SET CONNECTION statement.
||Disconnects the default connection. This is the connection made by a CONNECT statement which did not specify a connection
EXEC SQL CONNECT TO "srv1" AS server1 USER "sa." END-EXEC
EXEC SQL CONNECT TO "srv2" AS server2 USER "sa." END-EXEC
EXEC SQL DISCONNECT server1 END-EXEC
EXEC SQL DISCONNECT server2 END-EXEC.