use

Description

Accesses an existing database.

Syntax

use database_name 

Parameters

database_name

is the name of the database you want to access.

Examples

Example 1

use authors

Usage

• The DB2 access service returns the database name as part of the result set in an sp_sqlgetinfo call. It is located in the SQL_DATABASE_NAME attribute.

• If you issue a use database_name command with more than 127 characters, DirectConnect stores only the first 127 characters that you enter on this command.

Copyright © 2005. Sybase Inc. All rights reserved.

View this book as PDF