ASA SQL Reference
  SQL Statements

SET CONNECTION statement [Interactive SQL] [ESQL]

Description 

Use this statement to change the active database connection.

Syntax 

SET CONNECTION [connection-name]

connection-name :
identifier, string, or hostvar

Usage 

The SET CONNECTION statement changes the active database connection to connection-name. The current connection state is saved, and will be resumed when it again becomes the active connection. If connection-name is omitted and there is a connection that was not named, that connection becomes the active connection.

When cursors are opened in embedded SQL, they are associated with the current connection. When the connection is changed, the cursor names of the previously active connection become inaccessible. These cursors remain active and in position, and become accessible when the associated connection becomes active again.

Permissions 

None.

Side effects 

None.

See also 

CONNECT statement [ESQL] [Interactive SQL]

DISCONNECT statement [ESQL] [Interactive SQL]

Standards and compatibility 

• SQL/92    Interactive SQL use is a vendor extension. Embedded SQL is a Full level feature.

• SQL/99    Interactive SQL is a vendor extension. Embedded SQL is a core feature.

• Sybase    Supported by Open Client/Open Server.

Example 

The following example is in Embedded SQL.

EXEC SQL SET CONNECTION :conn_name;

From Interactive SQL, set the current connection to the connection named conn1.

SET CONNECTION conn1;