SET CONNECTION

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 ESQL/C.

Syntax

>>-SET CONNECTION----------------------------------------------->
 
>--+-+-'connection '------------------------+--+----------------+-+-><
   | |  (1)                                 |  |  (1)           | |
   | +--------connection_var----------------+  '--------DORMANT-' |
   | |  (1)                            (2)  |                     |
   | +--------| Database Environment |------+                     |
   | '-DEFAULT------------------------------'                     |
   |  (1)                                                         |
   '--------CURRENT DORMANT---------------------------------------'

Notes:

Informix extension
See page Database Environment

Element	Description	Restrictions	Syntax
connection	Name of the initial connection that the CONNECT statement made	The database must already exist	Quoted String, p. 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 current or to make the current connection dormant.

SET CONNECTION is not valid as a prepared statement.