Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
SQL statementsThis chapter describes the syntax and semantics of SQL statements that are recognized by HCL OneDB™.
SET CONNECTION statementUse 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 .

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:

¹ HCL OneDB™ extension
² 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.