User's Guide

Part V. The SQL Anywhere Programming Interfaces

Chapter 38. The WSQL HLI Interface

Syntax

     1. STOP USING DATABASE [ connection-name ]

     2. STOP USING DATABASE connect-string

     connection-name:    identifier, or host variable

Purpose

Form 1: to terminate a connection to a database engine or server. Form 2: to stop a database.

See also

START USING DATABASE, SET CONNECTION.

Description

Form 1 of this statement terminates a connection to the database.

This statement is functionally similar to the Embedded SQL command DISCONNECT. See "DISCONNECT statement". Form 2 of this statement stops, or unloads, a database from a named server.

Examples

The following statement uses form 1 to disconnect from the current database.

     STOP USING DATABASE

The following statement uses form 2 to stop the sample database on the engine server_name:

     STOP USING DATABASE "eng=server_name;dbn=sademo"