HP c-tree-SQL ISQL and Tools Instrukcja Użytkownika Pobierz pdf (Strona 42)

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 " ] ] ;

1 2 ... 37 38 39 40 41 42 43 44 45 46 47 ... 98 99

Brak uwag

HP c-tree-SQL ISQL and Tools Instrukcja Użytkownika Strona 42