isCOBOL Evolve : Language Reference : Embedded SQL Statements : CONNECT RESET
CONNECT RESET
The CONNECT RESET statement closes the connection with the database.
General format
EXEC SQL [ AT Database ]
 
  CONNECT RESET [ { DEFAULT } ]
                  { CURRENT } 
                  { ALL     }
 
END-EXEC
Syntax rules
1. CURRENT and DEFAULT are synonymous.
General rules
1. Unless the ALL prhase is specified, the current databae connection is closed.
2. When the ALL phrase is specified, all the active connections are closed.
3. Database identifies the active connection that will execute the query and must be previously defined using a Format 4 DECLARE statement.
Examples
Disconnect from the current connection
exec sql connect reset end-exec