read  set option

Chapter 2: Interactive SQL Commands

set connection

Description

Changes the current database connection to another server.

Syntax

set connection_name :
	identifier , string, or hostvar

Parameters

connection_name

is the login name you are using to make the connection.

identifier

is the identifier you are using for the connection information.

string

is the string you are using for the connection information.

hostvar

is the variable information for the host name and port.

Usage

The set connection statement changes the active database connection to another server. The current connection state is saved, and resumes again when it again becomes the active connection. If you omit connection_name and there is a connection that was not named, that connection becomes the active connection.

Permissions

Any user can execute this command.

See also

connect, disconnect





Copyright © 2005. Sybase Inc. All rights reserved. set option

View this book as PDF