Product Documentation

FairCom ISQL

Previous Topic

Next Topic

CLEAR

Syntax

CLEAR option ;

option::

HISTORY

| BREAK

| COLUMN

| COMPUTE

| DISPLAY

| TITLE

Description

The CLEAR statement removes settings made by the ISQL statement corresponding to option.

Argument

option

Which ISQL statement’s settings to clear:

  • CLEAR HISTORY - Clears the ISQL statement history buffer.
  • CLEAR BREAK - Clears the break set by the BREAK statement.
  • CLEAR COLUMN - Clears formatting options set by any COLUMN statements in effect.
  • CLEAR COMPUTE - Clears all the options set by the COMPUTE statement.
  • CLEAR DISPLAY - Clears the displays set by the DISPLAY statement.
  • CLEAR TITLE - Clears the titles set by the TITLE statement.

Examples

The following example illustrates clearing the DISPLAY and BREAK settings.


ISQL> DISPLAY -- See the DISPLAY settings currently in effect:

display "Break on change in value of customeer_name!" on customer_name

display "Break on every row!" on row

display "Break on page (page size set to 2 lines)" on page

display "Break on end of report!" on report

ISQL> CLEAR DISPLAY

ISQL> DISPLAY

No display specified.

ISQL> BREAK

break on report skip 0

ISQL> CLEAR BREAK

ISQL> BREAK

no break specified

ISQL>


TOCIndex