CLEAR Statement [Interactive SQL]

Closes any open result sets in Interactive SQL (dbisql).

Quick Links:

Go to Usage

Go to Standards

Go to Permissions

Syntax

CLEAR

Usage

(back to top)

Closes any open result sets and leaves the contents of the SQL Statements pane unchanged

Side effects:

The CLEAR statement closes the cursor associated with the data being cleared.

Standards

(back to top)

  • SQL—Vendor extension to ISO/ANSI SQL grammar.
  • SAP Sybase Database product—Not applicable.

Permissions

(back to top)

None

Related reference
EXIT Statement [Interactive SQL]