Filter
Top Products
ISQL and Tools
3-16 FairCom Corporation
| 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>
3.7.4 COLUMN
Syntax
COLUMN [ column_name
[ FORMAT " format_string " ] | [ HEADING " heading_text " ] ] ;