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 .
Making a current connection as the dormant connectionIn the SET CONNECTION connection DORMANT statement, connection must represent the current connection. The SET CONNECTION statement with the DORMANT option makes the specified current connection a dormant connection.

Making a current connection as the dormant connection

In the SET CONNECTION connection DORMANT statement, connection must represent the current connection. The SET CONNECTION statement with the DORMANT option makes the specified current connection a dormant connection.

For example, the following SET CONNECTION statement makes connection con1 dormant:

SET CONNECTION 'con1' DORMANT;

The SET CONNECTION statement with the DORMANT option generates an error if you specify a connection that is already dormant. For example, if connection con1 is current and connection con2 is dormant, the following SET CONNECTION statement returns an error message:

SET CONNECTION 'con2' DORMANT;

The following SET CONNECTION statement executes successfully:

SET CONNECTION 'con1' DORMANT;