disconnect  input

Chapter 2: Interactive SQL Commands

exit

Description

Leaves Interactive SQL.

Syntax

{ exit | quit | bye } [ return_code ]
	return_code: number | connection_variable

Parameters

exit | quit | bye

closes your connection with the database, then closes the Interactive SQL environment.

return_code

can be used in batch files to indicate success or failure of the commands in an Interactive SQL command file. The default return code is 0.

number

is the number of the return code.

connection_varible

is a variable indicating a specific connection.

Usage

Before closing the database connection, Interactive SQL automatically executes a commit statement if the commit_on_exit option is set to on. If this option is set to off, Interactive SQL performs an implicit rollback. By default, the commit_on_exit option is set to on.

Permissions

Any user can execute this command.





Copyright © 2005. Sybase Inc. All rights reserved. input

View this book as PDF