User's Guide

Part V. The SQL Anywhere Programming Interfaces

Chapter 38. The WSQL HLI Interface

Syntax

     SET CONNECTION [ connection-name ]

     connection-name:    identifier, or host variable

Purpose

To change active connections.

See also

START USING DATABASE, STOP USING DATABASE.

Description

This command changes the current database connection. You can use the START USING DATABASE command several times naming the connection each time. Each time, the new connection becomes the current connection. You can use the SET CONNECTION statement to make the named connection current.

This command is functionally identical to the Embedded SQL command of the same name. See "SET CONNECTION statement".