SET CONNECTION statement
Use the SET CONNECTION statement to reestablish a connection between an application and a database environment and to make the connection current. You can also use this statement with the DORMANT option to put the current connection in a dormant state. Use this statement with .
Syntax
Notes:
- 1 HCL OneDB™ extension
- 2 See Database Environment
| Element | Description | Restrictions | Syntax |
|---|---|---|---|
| connection | Name of the initial connection that the CONNECT statement made | The database must already exist | Quoted String |
| connection_var | Host variable that contains the value of connection | Must be a character data type | Language specific |
Usage
You can use SET CONNECTION to make a dormant connection the current connection or to make the current connection dormant.
SET CONNECTION is not valid as a prepared statement.