ASA SQL Reference
  SQL Statements

CLEAR statement [Interactive SQL]

Description 

Use this statement to clear the Interactive SQL panes.

Syntax 

CLEAR

Usage 

The CLEAR statement is used to clear the SQL Statements pane, the Messages pane and the Results, Messages, Plan, and UltraLite Plan tabs in the Results pane.

Permissions 

None.

Side effects 

Closes the cursor associated with the data being cleared.

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    Not applicable